ttCacheUidPwdSet

This built-in procedure lets you set the Oracle cache administration user and password within a system-managed wallet in TimesTen to connect to the Oracle database.

You only need to register the Oracle cache administration user ID and password once for each new database. You can change the Oracle cache administration password at any time.

Note:

If you defined CacheAdminWallet=1 as a first connection attribute (in the DSN or on the initial database connection), then the credentials registered with the ttCacheUidPwdSet are saved in an Oracle Wallet (this is the recommended method). If you defined CacheAdminWallet=0 as a first connection attribute, the credentials are stored in memory. See CacheAdminWallet.

Required Privilege

This procedure requires the CACHE_MANAGER privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Related Views

This procedure has no related views.

Syntax

ttCacheUidPwdSet('UID', 'PWD')

Parameters

ttCacheUidPwdSet has these parameters:

Parameter Type Description

Parameter	Type	Description
`UID`	`TT_VARCHAR (30)`	The Oracle cache administration user ID that is used for cache operations. It is usually represented in examples as `cacheadmin`. Calling `ttCacheUidPwdSet`() without a `UID` or with a null value for the `UID` erases the stored UID.
`PWD`	`TT_VARCHAR (30)`	The password for the Oracle cache administration user. It is usually referred as `OraclePWD` and represented in examples as `orapwd`.

UID

TT_VARCHAR (30)

The Oracle cache administration user ID that is used for cache operations. It is usually represented in examples as cacheadmin.

Calling ttCacheUidPwdSet() without a UID or with a null value for the UID erases the stored UID.

PWD

TT_VARCHAR (30)

The password for the Oracle cache administration user. It is usually referred as OraclePWD and represented in examples as orapwd.

Result Set

ttCacheUidPwdSet returns no results.

Examples

The first example shows setting the Oracle cache administration user and password using ttCacheUidPwdSet built-in procedure. Then, the example calls ttCacheUidGet to show the Oracle cache administration user that is set in TimesTen. The next part of the example shows that if you do not provide any values for the Oracle cache administration in the ttCacheUidPwdSet built-in procedure, then the Oracle cache administration user is erased.

Command> CALL ttCacheUidPwdSet ('cacheadmin','orapwd');
Command> CALL ttCacheUidGet;
< CACHEADMIN >
1 row found.
Command> CALL ttCacheUidPwdSet();
Command> CALL ttCacheUidGet;
< <NULL> >
1 row found.

Notes

This procedure cannot be called from an unencrypted client/server connection.
This procedure is available only for cache operations
For all levels of DDLReplicationLevel, you can set the cache administration user ID and password while the cache or replication agents are running. For more details on changing the cache administration user ID or password, see Changing Cache User Names and Passwords in Oracle TimesTen In-Memory Database Cache Guide.
The cache administration user ID cannot be reset while there are cache groups on the database. The cache administration password can be changed at any time.