Set the Cache Administrator User Name and Password

The cache administration user creates, owns and maintains Oracle objects that store information used to manage a specific cache grid and enforce predefined behaviors of particular cache group types. After this user is defined, you must set its user name and password in the TimesTen database. (Cache grids apply only to TimesTen 11g or later.)

To set the cache administration user name and password, right-click the node that contains the name of your database connection and select Set Cache Administration User.

In the Prompts tab of the Setting the cache administration user dialog box, specify the cache administration user name in the Cache administration ID field, if this field does not already contain a user name, and the corresponding password for this user in the Cache administration password field. Then click the Apply button to set the cache administration user name and password in the TimesTen database.

The cache administration user name and password need to be set only once in each TimesTen database that will cache Oracle data unless it needs to be changed. For example, if the TimesTen database is destroyed and re-created, or the cache administration user name is dropped and re-created in the Oracle database, the cache administration user name and password must be set again.

Related Topics

TimesTen Tasks

SQL Developer Concepts and Usage