Grant Privileges to the TimesTen Users

The privileges that the TimesTen users require depend on the types of cache groups you create and the operations that you perform on the cache groups.

All of the privileges required for the TimesTen cache administration user for each cache operation are listed in Required Privileges for Cache Administration User for Cache Operations.

You must grant required privileges to the cache administration user. This example grants the TimesTen cache administration user cacheadmin the following required privileges to perform the noted operations:

• Set the cache administration user and password (CACHE_MANAGER).

• Start or stop the cache agent and replication agent processes on the TimesTen database (CACHE_MANAGER).

• Set a cache agent start policy (CACHE_MANAGER).

• Set a replication agent start policy (ADMIN)

• Create cache groups to be owned by the TimesTen cache administration user (CREATE [ANY] CACHE GROUP, inherited by the CACHE_MANAGER privilege; CREATE [ANY] TABLE to create the underlying cache tables which are to be owned by the cache table user).

• Alter, load, refresh, flush, unload or drop a cache group requires the appropriate privilege:

  • ALTER ANY CACHE GROUP

  • LOAD {ANY CACHE GROUP | ON cache_group_name

  • REFRESH {ANY CACHE GROUP | ON cache_group_name

  • FLUSH {ANY CACHE GROUP | ON cache_group_name

  • UNLOAD {ANY CACHE GROUP | ON cache_group_name

  • DROP ANY CACHE GROUP and DROP ANY TABLE

• Required privileges for other cache operations, such as for read-only cache groups, dynamic load operations, incremental autorefresh, full autorefresh and asynchronous writethrough, are listed in Required Privileges for Cache Administration User for Cache Operations.

As the instance administrator, use the ttIsql utility to grant the cacheadmin cache administration user the required privileges:

Command> GRANT CREATE SESSION, CACHE_MANAGER, CREATE ANY TABLE TO cacheadmin;
Command> exit