SELECT_CATALOG_ROLE

SELECT_CATALOG_ROLE

To use any DBA management application other than SQL*Plus Worksheet as a non-DBA user, you must have been granted the SELECT_CATALOG_ROLE. The SELECT_CATALOG_ROLE is only available for Oracle8 and above databases.

To create the SELECT_CATALOG_ROLE on Oracle databases prior to Oracle8, run the script documented below.

To create the script easily, you can cut and paste the script text from the online help.

sc_role.sql

CREATE ROLE SELECT_CATALOG_ROLE NOT IDENTIFIED;

grant select on SYS.V_$CONTROLFILE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LOG to SELECT_CATALOG_ROLE;

grant select on SYS.V_$THREAD to SELECT_CATALOG_ROLE;

grant select on SYS.V_$PROCESS to SELECT_CATALOG_ROLE;

grant select on SYS.V_$BGPROCESS to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SESSION to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LICENSE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$TRANSACTION to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LOCKED_OBJECT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LATCH to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LATCH_CHILDREN to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LATCH_PARENT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LATCHNAME to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LATCHHOLDER to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LATCH_MISSES to SELECT_CATALOG_ROLE;

grant select on SYS.V_$RESOURCE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$_LOCK to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LOCK to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SESSTAT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$MYSTAT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SYSSTAT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$STATNAME to SELECT_CATALOG_ROLE;

grant select on SYS.V_$ACCESS to SELECT_CATALOG_ROLE;

grant select on SYS.V_$OBJECT_DEPENDENCY to SELECT_CATALOG_ROLE;

grant select on SYS.V_$DBFILE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$FILESTAT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LOGFILE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$ROLLNAME to SELECT_CATALOG_ROLE;

grant select on SYS.V_$ROLLSTAT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SGA to SELECT_CATALOG_ROLE;

grant select on SYS.V_$PARAMETER to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SYSTEM_PARAMETER to SELECT_CATALOG_ROLE;

grant select on SYS.V_$ROWCACHE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$ENABLEDPRIVS to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LIBRARYCACHE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$TYPE_SIZE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$ARCHIVE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$CIRCUIT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$DATABASE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$INSTANCE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$DISPATCHER to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LOGHIST to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SQLAREA to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SQLTEXT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SQLTEXT_WITH_NEWLINES to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SQL to SELECT_CATALOG_ROLE;

grant select on SYS.V_$DB_PIPES to SELECT_CATALOG_ROLE;

grant select on SYS.V_$DB_OBJECT_CACHE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$OPEN_CURSOR to SELECT_CATALOG_ROLE;

grant select on SYS.V_$PQ_SYSSTAT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$PQ_SLAVE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$QUEUE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$MTS to SELECT_CATALOG_ROLE;

grant select on SYS.V_$DBLINK to SELECT_CATALOG_ROLE;

grant select on SYS.V_$PWFILE_USERS to SELECT_CATALOG_ROLE;

grant select on SYS.V_$REQDIST to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SGASTAT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$WAITSTAT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SHARED_SERVER to SELECT_CATALOG_ROLE;

grant select on SYS.V_$TIMER to SELECT_CATALOG_ROLE;

grant select on SYS.V_$RECOVER_FILE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$LOG_HISTORY to SELECT_CATALOG_ROLE;

grant select on SYS.V_$RECOVERY_LOG to SELECT_CATALOG_ROLE;

grant select on SYS.V_$DATAFILE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$FIXED_TABLE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$FIXED_VIEW_DEFINITION to SELECT_CATALOG_ROLE;

grant select on SYS.V_$INDEXED_FIXED_COLUMN to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SESSION_CURSOR_CACHE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SESSION_WAIT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SESSION_EVENT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SESSION_CONNECT_INFO to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SYSTEM_EVENT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$EVENT_NAME to SELECT_CATALOG_ROLE;

grant select on SYS.V_$EXECUTION to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SYSTEM_CURSOR_CACHE to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SESS_IO to SELECT_CATALOG_ROLE;

grant select on SYS.V_$COMPATIBILITY to SELECT_CATALOG_ROLE;

grant select on SYS.V_$COMPATSEG to SELECT_CATALOG_ROLE;

grant select on SYS.V_$RECOVERY_STATUS to SELECT_CATALOG_ROLE;

grant select on SYS.V_$RECOVERY_FILE_STATUS to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SHARED_POOL_RESERVED to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SORT_SEGMENT to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SQL_CURSOR to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SQL_BIND_METADATA to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SQL_BIND_DATA to SELECT_CATALOG_ROLE;

grant select on SYS.V_$SQL_SHARED_MEMORY to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_ROLES to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_PROFILES to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_CATALOG to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_CLUSTERS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_CLU_COLUMNS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_COL_COMMENTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_COL_PRIVS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_DB_LINKS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_EXP_OBJECTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_EXP_VERSION to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_EXP_FILES to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_INDEXES to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_IND_COLUMNS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_OBJECTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_ROLLBACK_SEGS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_ROLE_PRIVS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_SYS_PRIVS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_SEQUENCES to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_SYNONYMS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_TABLES to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_TAB_COLUMNS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_TAB_COMMENTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_TAB_PRIVS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_TS_QUOTAS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_USERS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_VIEWS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_CONSTRAINTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_CLUSTER_HASH_EXPRESSIONS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_CONS_COLUMNS to SELECT_CATALOG_ROLE;

grant select on SYS.SYSCATALOG_ to SELECT_CATALOG_ROLE;

grant select on SYS.PSS1$ to SELECT_CATALOG_ROLE;

grant select on SYS.PS1$ to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_2PC_PENDING to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_2PC_NEIGHBORS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_UPDATABLE_COLUMNS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_OBJ_AUDIT_OPTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_STMT_AUDIT_OPTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_PRIV_AUDIT_OPTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_AUDIT_TRAIL to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_AUDIT_SESSION to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_AUDIT_STATEMENT to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_AUDIT_OBJECT to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_AUDIT_EXISTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_ERRORS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_SOURCE to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_TRIGGERS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_TRIGGER_COLS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_DEPENDENCIES to SELECT_CATALOG_ROLE;

grant select on SYS.CODE_PIECES to SELECT_CATALOG_ROLE;

grant select on SYS.CODE_SIZE to SELECT_CATALOG_ROLE;

grant select on SYS.PARSED_PIECES to SELECT_CATALOG_ROLE;

grant select on SYS.PARSED_SIZE to SELECT_CATALOG_ROLE;

grant select on SYS.SOURCE_SIZE to SELECT_CATALOG_ROLE;

grant select on SYS.ERROR_SIZE to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_OBJECT_SIZE to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_JOBS_RUNNING to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_JOBS to SELECT_CATALOG_ROLE;

grant select on SYS.ORA_KGLR7_OBJECTS to SELECT_CATALOG_ROLE;

grant select on SYS.SYS_OBJECTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_SEGMENTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_EXTENTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_FREE_SPACE to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_FREE_SPACE_COALESCED_TMP1 to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_FREE_SPACE_COALESCED_TMP2 to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_FREE_SPACE_COALESCED to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_DATA_FILES to SELECT_CATALOG_ROLE;

grant select on SYS.FILEXT$ to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_TABLESPACES to SELECT_CATALOG_ROLE;

grant select on SYS.SM$TS_AVAIL to SELECT_CATALOG_ROLE;

grant select on SYS.SM$TS_USED to SELECT_CATALOG_ROLE;

grant select on SYS.SM$TS_FREE to SELECT_CATALOG_ROLE;

grant select on SYS.SM$AUDIT_CONFIG to SELECT_CATALOG_ROLE;

grant select on SYS.SM$INTEGRITY_CONS to SELECT_CATALOG_ROLE;

grant select on SYS.DEFSCHEDULE to SELECT_CATALOG_ROLE;

grant select on SYS.DEFERROR to SELECT_CATALOG_ROLE;

grant select on SYS.DEFERRCOUNT to SELECT_CATALOG_ROLE;

grant select on SYS.DEFTRAN to SELECT_CATALOG_ROLE;

grant select on SYS.DEFTRANDEST to SELECT_CATALOG_ROLE;

grant select on SYS.DEFDEFAULTDEST to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_SNAPSHOTS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_SNAPSHOT_LOGS to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_RCHILD to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_RGROUP to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_REFRESH to SELECT_CATALOG_ROLE;

grant select on SYS.DBA_REFRESH_CHILDREN to SELECT_CATALOG_ROLE;

Note: This script will have to be run as SYS.