Changing User Names or Passwords Used by Replication

In the active standby pair, you can modify either the TimesTen user name or password or (if there are cache groups in the active standby pair) the user names and passwords for the TimesTen cache administration user or its companion Oracle cache administration user.

When the DDLReplicationLevel connection attribute is 2 or larger, changes to the user names or passwords executed on the active master are automatically replicated to the standby master and any subscribers. When the DDLReplicationLevel connection attribute is 1, changes to the user names or passwords executed on the active master are not automatically replicated to the standby master and any subscribers. In this case, you must manually run each SQL statement on the active master, standby master, and any subscribers.

Note:

See Making DDL Changes in an Active Standby Pair.

Perform the following to change any of the user names or passwords for the TimesTen user or, if there are cache groups in the active standby pair, for the TimesTen cache administration user or the Oracle cache administration user:

1. If you want to modify a password of a TimesTen user, use the ALTER USER statement on the active master database. If you want to change the TimesTen user name, you must first drop all objects that the TimesTen user owns before dropping the user name and creating a new user.

   To modify the password of the sales schema owner:

   Note:

   See Creating or Identifying a Database User in Oracle TimesTen In-Memory Database Operations Guide.

   ALTER USER sales IDENTIFIED BY newpwd;

2. If you want to modify any of the user names or passwords used for cache operations (such as the cache administration user), perform the instructions provided in Changing Cache User Names and Passwords in the Oracle TimesTen In-Memory Database Cache Guide.