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 ****