The checkAdminPrivileges.sql Script

The checkAdminPrivileges.sql script checks that the cache administration user has been granted the required privileges to automatically create Oracle Database objects used to manage the caching of Oracle Database data when particular cache group operations are performed. This script checks that the user running the script has all of the privileges granted in the grantCacheAdminPrivileges.sql script.

See Required Privileges for Cache Administration User for Cache Operations for a complete list of privileges that need to be granted to the cache administration user in order to perform particular cache group and cache table operations.

Run the timesten_home/install/oraclescripts/checkAdminPrivileges.sql as the cache administration user.

Use SQL*Plus on the Oracle Database system from an operating system shell or command prompt, and connect to the Oracle database instance as the cache administration user that you want checked for privileges. The following example shows that the user has all of the required privileges.

SQL> @checkAdminPrivileges.sql 
**** Checking privileges for cache administrator user ****
**** User has all privileges for a cache administrator user ****

The following example shows the output if you have missing privileges needed as a cache administration user on an Oracle database:

SQL> @checkAdminPrivileges.sql
**** Checking privileges for cache administrator user **** 
Missing CREATE OPERATOR
Missing CREATE INDEXTYPE
Missing CREATE CLUSTER
Missing EXECUTE ON SYS.DBMS_LOCK
Missing EXECUTE ON SYS.DBMS_DDL
Missing EXECUTE ON SYS.DBMS_FLASHBACK
Missing EXECUTE ON SYS.DBMS_LOB
Missing SELECT on SYS.GV$LOCK
Missing SELECT on SYS.GV$SESSION
Missing SELECT on SYS.DBA_DATA_FILES
Missing SELECT on SYS.V$DATABASE
Missing SELECT on GV$PROCESS
Missing UNLIMITED TABLESPACE
Missing SELECT ANY TRANSACTION
Missing table ARDL_CG_COUNTER
**** User missing privileges. Missing privilege count: 15 ****