Oracle® TimesTen In-Memory Database Reference Release 11.2.1 Part Number E13069-03 |
|
|
View PDF |
Description
Sets the cache administration user ID and password. The cache administration user ID and password only need to be specified once for each new data store. The cache administration password can be changed at any time.
This procedure requires the CACHE_MANAGER privilege.
Syntax
ttCacheUidPwdSet('UID', 'PWD')
Parameters
ttCacheUidPwdSet has these parameters:
Parameter | Type | Description |
---|---|---|
UID |
TT_VARCHAR (30) | The cache administration user ID, used for AUTOREFRESH and ASYNCHRONOUS WRITETHROUGH cache groups. |
PWD |
TT_VARCHAR (30) | The password for the cache administration user. |
Result set
ttCacheUidPwdSet returns no results.
Example
CALL ttCacheUidPwdSet('myid', 'mypwd');
Notes
This procedure cannot be called from a Client/Server connection.
This procedure is available only for IMDB Cache.
The cache administration user ID and password cannot be set while either the cache agent or the replication agent are running.
The cache administration user ID cannot be reset while there are ASYNCHRONOUS WRITETHROUGH cache groups or AUTOREFRESH cache groups (with a state that is not equal to OFF) on the data store.
See also