Changing Cache User Names and Passwords

You can change any of the user names or passwords for the TimesTen cache administration user or its companion Oracle cache administration user.

If you want to modify the TimesTen cache administration user or password, perform the following:

Note:

Passwords for both the TimesTen cache administration user and its companion Oracle cache administration user can be changed at any time.

The name for the TimesTen cache administration user must be the same as its companion Oracle cache administration user; however, the passwords may be different. See Create the TimesTen Users.
1. On the TimesTen database, if you want to modify the password of the TimesTen cache administration user, then use the ALTER USER statement on the active master.
```
Command> ALTER USER cacheadmin IDENTIFIED BY newpwd;
```
2. On the back-end Oracle database, you can modify the companion Oracle cache administration user password with the ALTER USER statement. If you are working on TimesTen, you can use Passthrough 3 to run this directly on the Oracle database.
```
Command> passthrough 3; 
Command> ALTER USER cacheadmin IDENTIFIED BY newpwd;
```
  Note:
  
  If you have modified the password for the companion Oracle cache administration user, reconnect to the TimesTen database as the TimesTen cache administration user providing passwords for the TimesTen cache administration user and its companion Oracle cache administration user.
3. If you want to change the TimesTen cache administration user, you must first drop all cache groups that the TimesTen cache administration user owns before dropping the existing user and creating a new user. The Oracle cache administration user name can only be changed when there are no cache groups on the TimesTen database.
  
  Note:
  
  Alternatively, if you want to use a different user as the TimesTen cache administration user, ensure that it has the correct privileges and a companion Oracle cache administration user with the correct privileges.
  
  In addition, since the TimesTen cache administration user must have a companion Oracle cache administration user with the same name, you must either:
  - Drop all tables owned by the current companion Oracle cache administration user, drop the user, and then re-create it with the same name as the new TimesTen cache administration user.
  - Choose another Oracle user that has the same name as the TimesTen cache administration user and provides the same functionality.
  See Create the TimesTen Users.
4. On TimesTen Classic, if the TimesTen cache administration user name or password are defined in the sys.odbc.ini (or odbc.ini) file, update the new TimesTen cache administration user name or password in the sys.odbc.ini (or odbc.ini) file on both the active and standby masters.
If you want to modify the Oracle cache administration user or its password, perform the following:
1. On the back-end Oracle database, you can modify the Oracle cache administration password with the ALTER USER statement. The password of the Oracle cache administration user can be changed at any time.
  
  If you are working on TimesTen, you can use Passthrough 3 to run this directly on the Oracle database.
```
Command> passthrough 3; 
Command> ALTER USER cacheadmin IDENTIFIED BY newpwd;
```
2. If you want to change the Oracle cache administration user, you must first drop all cache groups on the TimesTen database that the Oracle cache administration user manages before you can drop the Oracle cache administration user on the Oracle database and create a new user. Dropping the cache groups on TimesTen removes all metadata associated with those cache groups.
  
  When you create a new Oracle cache administration user on the Oracle database, you must follow the same instructions for creating a Oracle cache administration user that are provided in the Create the Oracle Database Users and Default Tablespace.
3. Set the new user name or password for the Oracle cache administration user.
  - On TimesTen Classic, run the ttCacheUidPwdSet built-in procedure on the active master database.
    
    Note:
    
    See Registering the Cache Administration User Name and Password.
```
Command> call ttCacheUidPwdSet('cacheadmin','newpwd');
```
  - On TimesTen Scaleout, run the ttGridAdmin dbCacheCredentialSet command.
    
    Note:
    
    See Set the Cache Administration User Name and Password in the TimesTen Database in the Oracle TimesTen In-Memory Database Cache Guide.
```
% ttGridAdmin dbCacheCredentialSet database1
Provide Oracle user id: cacheadmin
Provide Oracle password: oracle
```