Grant Privileges to the Oracle Cache Administration User

The cache administration user must be granted a high level of privileges depending on the cache group types created and the operations performed on these cache groups.

The main privileges required for the Oracle cache administration user can be granted in bulk by running the SQL*Plus script timesten_home/install/oraclescripts/grantCacheAdminPrivileges.sql as the sys user. This script grants the cache administration user the minimum set of privileges required to perform cache operations.

If you are using a multitenant container database (CDB) or pluggable database (PDB), run the SQL*Plus script timesten_home/install/oraclescripts/grantCacheAdminPrivileges.sql to assign cache privileges as follows:

• If the cache administrator user is a local user: You must assign cache privileges only within the PDB in which this user exists. This is the preferred method.

• If the cache administrator user is a common user: You must assign cache privileges within each PDB in the CDB in which you want to use cache. Do not run the SQL*Plus script to grant privileges to the common user in the CBD root.

See Create Oracle Database Objects Used to Manage Data Caching.

You also need to grant the Oracle cache administration user privileges based on the type of cache operation. The entire list of privileges required for this user for each cache operation are listed in Required Privileges for Cache Administration User for Cache Operations.