Oracle Tips and Tricks — David Fitzjarrell

April 30, 2008

Where, O Where Has That Table Gone?

Filed under: General — dfitzjarrell @ 14:35

It’s frustrating to be told to query a table or a view and, upon doing so, receive:

ERROR at line 1:
ORA-00942: table or view does not exist

Especially when you know the table or view in question is part of the standard Oracle database catalogue. It’s there, so why can’t you see it?

It all boils down to one of two things: privilege or the existence of a synonym.

Without at least a select grant on the table or view that’s ‘missing in action’ (either directly or through a role) you’ll never get to view the contents of the table or view in question. And, without a synonym you’ll not be able to access that table/view simply by name. Granted, some organizations don’t allow access to DBA-related views/tables by non-DBA user accounts, but if your company does allow such access (even in a limited scope) reading further will shed some light on what may be the problem and what can be done to correct it.

Let’s take a plain vanilla user account and see what transpires when we try to access data dictionary views without being granted the necessary role or privilege:

SQL> select instance_name from v$instance;
select instance_name from v$instance
                          *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>

Of course the view V$INSTANCE exists; any DBA can readily view its contents. So the problem must be privileges, or lack thereof. Let’s rectify that issue by granting SELECT_CATALOG_ROLE to our user and trying again [this is NOT a role to be granted lightly or to everyone on the planet as it grants select access to tables and views not every user should be able to query. To recreate that role the following scripts would be necessary:

CREATE ROLE HS_ADMIN_ROLE NOT IDENTIFIED;
GRANT EXECUTE ON  "SYS"."DBMS_HS" TO HS_ADMIN_ROLE;
GRANT EXECUTE ON  "SYS"."DBMS_HS_EXTPROC" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_ALL_CAPS" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_ALL_DD" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_ALL_INITS" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_BASE_CAPS" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_BASE_DD" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_CLASS_CAPS" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_CLASS_DD" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_CLASS_INIT" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_EXTERNAL_OBJECTS" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_EXTERNAL_OBJECT_PRIVILEGES" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_EXTERNAL_USER_PRIVILEGES" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_FDS_CLASS" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_FDS_INST" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_INST_CAPS" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_INST_DD" TO HS_ADMIN_ROLE;
GRANT SELECT ON  "SYS"."HS_INST_INIT" TO HS_ADMIN_ROLE;

CREATE ROLE SELECT_CATALOG_ROLE NOT IDENTIFIED;
GRANT SELECT ON  "SYS"."CODE_PIECES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."CODE_SIZE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_2PC_NEIGHBORS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_2PC_PENDING" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_ALL_TABLES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_ASSOCIATIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_AUDIT_EXISTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_AUDIT_OBJECT" 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_TRAIL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_CACHEABLE_OBJECTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_CACHEABLE_TABLES" 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_CLUSTER_HASH_EXPRESSIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_CLU_COLUMNS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_COLL_TYPES" 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_CONSTRAINTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_CONS_COLUMNS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_CONTEXT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DATA_FILES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DB_LINKS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DEPENDENCIES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DIMENSIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DIM_ATTRIBUTES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DIM_CHILD_OF" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DIM_HIERARCHIES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DIM_JOIN_KEY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DIM_LEVELS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DIM_LEVEL_KEY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DIRECTORIES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DMT_FREE_SPACE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_DMT_USED_EXTENTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_ERRORS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_EXP_FILES" 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_EXTENTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_FREE_SPACE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_FREE_SPACE_COALESCED" 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_TMP3" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_CONSTRAINT_EXP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_GEN_STMTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_GEN_STMTS_EXP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_OBJECTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_OBJECTS_BASE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_OBJECTS_EXP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_POSTGEN_STMTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_PREGEN_STMTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_SITES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IAS_TEMPLATES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_INDEXES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_INDEXTYPES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_INDEXTYPE_OPERATORS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IND_COLUMNS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IND_EXPRESSIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IND_PARTITIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_IND_SUBPARTITIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_INTERNAL_TRIGGERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_JOBS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_JOBS_RUNNING" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_LIBRARIES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_LMT_FREE_SPACE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_LMT_USED_EXTENTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_LOBS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_LOB_PARTITIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_LOB_SUBPARTITIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_METHOD_PARAMS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_METHOD_RESULTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_MVIEWS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_MVIEW_AGGREGATES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_MVIEW_ANALYSIS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_MVIEW_DETAIL_RELATIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_MVIEW_JOINS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_MVIEW_KEYS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_NESTED_TABLES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OBJECTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OBJECT_SIZE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OBJECT_TABLES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OBJ_AUDIT_OPTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OPANCILLARY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OPARGUMENTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OPBINDINGS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OPERATORS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OUTLINES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_OUTLINE_HINTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PARTIAL_DROP_TABS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PART_COL_STATISTICS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PART_HISTOGRAMS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PART_INDEXES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PART_KEY_COLUMNS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PART_LOBS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PART_TABLES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PENDING_TRANSACTIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_POLICIES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PRIV_AUDIT_OPTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_PROFILES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_QUEUES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_QUEUE_SCHEDULES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_QUEUE_TABLES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_RCHILD" 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;
GRANT SELECT ON  "SYS"."DBA_REFS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REGISTERED_SNAPSHOTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REGISTERED_SNAPSHOT_GROUPS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPAUDIT_ATTRIBUTE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPAUDIT_COLUMN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCATLOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCAT_REFRESH_TEMPLATES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCAT_TEMPLATE_OBJECTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCAT_TEMPLATE_PARMS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCAT_TEMPLATE_SITES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCAT_USER_AUTHORIZATIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCAT_USER_PARM_VALUES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCOLUMN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCOLUMN_GROUP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPCONFLICT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPDDL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPFLAVORS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPFLAVOR_COLUMNS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPFLAVOR_OBJECTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPGENERATED" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPGENOBJECTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPGROUP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPGROUPED_COLUMN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPGROUP_PRIVILEGES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPKEY_COLUMNS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPOBJECT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPPARAMETER_COLUMN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPPRIORITY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPPRIORITY_GROUP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPPROP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPRESOLUTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPRESOLUTION_METHOD" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPRESOLUTION_STATISTICS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPRESOL_STATS_CONTROL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPSCHEMA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_REPSITES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_RGROUP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_ROLE;S" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_ROLE;_PRIVS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_ROLLBACK_SEGS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_RSRC_CONSUMER_GROUPS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_RSRC_CONSUMER_GROUP_PRIVS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_RSRC_MANAGER_SYSTEM_PRIVS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_RSRC_PLANS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_RSRC_PLAN_DIRECTIVES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_RULESETS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SEGMENTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SEQUENCES" 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_SNAPSHOT_LOG_FILTER_COLS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SNAPSHOT_REFRESH_TIMES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SOURCE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_STMT_AUDIT_OPTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SUBPART_COL_STATISTICS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SUBPART_HISTOGRAMS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SUBPART_KEY_COLUMNS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SUMMARIES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SUMMARY_AGGREGATES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SUMMARY_DETAIL_TABLES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SUMMARY_JOINS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SUMMARY_KEYS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SYNONYMS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_SYS_PRIVS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TABLES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TABLESPACES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TAB_COLUMNS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TAB_COL_STATISTICS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TAB_COMMENTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TAB_HISTOGRAMS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TAB_MODIFICATIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TAB_PARTITIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TAB_PRIVS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TAB_SUBPARTITIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TEMP_FILES" 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_TS_QUOTAS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TYPES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TYPE_ATTRS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_TYPE_METHODS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_UNUSED_COL_TABS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_UPDATABLE_COLUMNS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_USERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_USTATS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_VARRAYS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DBA_VIEWS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DEFCALL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DEFCALLDEST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DEFDEFAULTDEST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DEFERRCOUNT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DEFERROR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DEFLOB" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DEFPROPAGATOR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."DEFSCHEDULE" 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"."ERROR_SIZE" TO SELECT_CATALOG_ROLE;
--
-- EXP/IMP views
--
-- These views 'power' the traditional EXP/IMP utilities
-- 
-- Will be release-specific which will be indicated
-- in the table name
--
-- EXU8 views found in release 8.0 and apply to that release 
-- and all later releases unless replaced by a later version
--
-- EXU81 found in 8.1.0 and later releases, replacing  
-- the corresponding EXU8 views
--
-- Supplied for backward compatibility in all current releases
-- of Oracle
-- 
-- These views, if found invalid, can be recreated with the
-- $ORACLE_HOME/rdbms/admin/catexp.sql script
-- Please read here for instructions
--
GRANT SELECT ON  "SYS"."EXU816SQV" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU816TCTX" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU816TGR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU816TGRC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU816TGRI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU816TGRIC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81CTX" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81DOI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81FIL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81INDC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81INDI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81INDIC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81ITY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81ITYC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81ITYI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81IXCP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81IXSP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81JAVC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81JAVI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81LBCP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81LBP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81LBSP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81OBJ" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81OPR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81OPRC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81OPRI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81PLB" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81PSTC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81PSTI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81REFC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81REFI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81RGC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81RGS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SCM" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SLFC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SNAP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SNAPC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SNAPI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SNAPL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SNAPLC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SNAPLI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SPOK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SPOKI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81SRT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TAB" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TABC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TABI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TABS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TBCP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TBS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TBSP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TGR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TGRC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TGRI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TGRIC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TNTC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TNTI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81TYP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU81USCI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8ANAL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8ASC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8AUD" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8CCL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8CCO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8CGR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8CLU" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8CLUC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8CLUI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8CMT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8COE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8COL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8COLNN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8COL_TEMP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8CON" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8COO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8CSN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8DEL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8DELSNAP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8DELSNAPL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8DFR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8DIMC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8DIMI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8DIR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8ERC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8FIL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8FPT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8GRN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8GRS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8HST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8ICO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8IND" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8INDC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8INDI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8INDIC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8INK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8IOV" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8IXP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8JBQ" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8LIB" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8LNK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8LOB" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8NTB" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8NXP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8OID" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PDS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PHS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PNT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8POK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8POKI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PRF" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PRR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PSTC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PSTI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PSTIC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8PVF" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8REF" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8REFC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8REFI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8REFIC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8RFS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8RGC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8RGS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8RIF" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8RLG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8ROL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8RSG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SCM" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SEQ" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SLFC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SLOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SNAP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SNAPC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SNAPI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SNAPL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SNAPLC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SNAPLI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SPR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SPRC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SPRI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SPS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SPV" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SRT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8STO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SYN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SYNC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8SYNI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TAB" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TABC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TABI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TBP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TBS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TGR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TGRC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TGRI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TGRIC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TNTC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TNTI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TNTIC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TSL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TSN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TSQ" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TYP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TYPB" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8TYPT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8USR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VDPT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VEW" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VEWC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VEWI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VINF" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VINFC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VINFI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VNC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VNCC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."EXU8VNCI" TO SELECT_CATALOG_ROLE;
--
-- End of EXP/IMP views
--
GRANT SELECT ON  "SYS"."FILEXT$" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ACCESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$AQ" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$AQ1" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ARCHIVE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ARCHIVED_LOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ARCHIVE_DEST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ARCHIVE_PROCESSES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BACKUP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BACKUP_ASYNC_IO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BACKUP_CORRUPTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BACKUP_DATAFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BACKUP_DEVICE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BACKUP_PIECE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BACKUP_REDOLOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BACKUP_SET" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BACKUP_SYNC_IO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BGPROCESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BSP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BUFFER_POOL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$BUFFER_POOL_STATISTICS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$CIRCUIT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$CLASS_PING" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$COMPATIBILITY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$COMPATSEG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$CONTEXT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$CONTROLFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$CONTROLFILE_RECORD_SECTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$COPY_CORRUPTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DATABASE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DATAFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DATAFILE_COPY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DATAFILE_HEADER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DBFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DBLINK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DB_CACHE_ADVICE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DB_OBJECT_CACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DB_PIPES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DELETED_OBJECT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DISPATCHER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DISPATCHER_RATE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DLM_ALL_LOCKS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DLM_CONVERT_LOCAL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DLM_CONVERT_REMOTE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DLM_LATCH" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DLM_LOCKS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DLM_MISC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DLM_RESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$DLM_TRAFFIC_CONTROLLER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ENABLEDPRIVS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ENQUEUE_LOCK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$EVENT_NAME" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$EXECUTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$FAST_START_SERVERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$FAST_START_TRANSACTIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$FILESTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$FILE_PING" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$FIXED_TABLE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$FIXED_VIEW_DEFINITION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$GLOBAL_BLOCKED_LOCKS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$GLOBAL_TRANSACTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$HS_AGENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$HS_PARAMETER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$HS_SESSION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$INDEXED_FIXED_COLUMN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$INSTANCE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$INSTANCE_RECOVERY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LATCH" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LATCHHOLDER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LATCHNAME" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LATCH_CHILDREN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LATCH_MISSES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LATCH_PARENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LIBRARYCACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LICENSE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOCK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOCKED_OBJECT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOCKS_WITH_COLLISIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOCK_ELEMENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOGFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOGHIST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOGMNR_CONTENTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOGMNR_DICTIONARY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOGMNR_LOGS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOGMNR_PARAMETERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$LOG_HISTORY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$MTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$MYSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$OBJECT_DEPENDENCY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$OBSOLETE_PARAMETER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$OFFLINE_RANGE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$OPEN_CURSOR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PARAMETER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PARAMETER2" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PQ_SLAVE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PQ_SYSSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PROCESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PROXY_ARCHIVEDLOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PROXY_DATAFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PWFILE_USERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PX_PROCESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PX_PROCESS_SYSSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PX_SESSION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$PX_SESSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$QUEUE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$RECOVERY_FILE_STATUS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$RECOVERY_LOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$RECOVERY_PROGRESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$RECOVERY_STATUS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$RECOVER_FILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$REQDIST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$RESERVED_WORDS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$RESOURCE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$RESOURCE_LIMIT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ROLLSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ROWCACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ROWCACHE_PARENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$ROWCACHE_SUBORDINATE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SESSION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SESSION_CONNECT_INFO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SESSION_CURSOR_CACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SESSION_EVENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SESSION_OBJECT_CACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SESSION_WAIT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SESSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SESS_IO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SGA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SGASTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SHARED_POOL_RESERVED" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SHARED_SERVER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SORT_SEGMENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SORT_USAGE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SQL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SQLAREA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SQLTEXT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SQLTEXT_WITH_NEWLINES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SQL_BIND_DATA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SQL_BIND_METADATA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SQL_CURSOR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SQL_SHARED_CURSOR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SQL_SHARED_MEMORY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$STATNAME" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SUBCACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SYSSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SYSTEM_CURSOR_CACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SYSTEM_EVENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SYSTEM_PARAMETER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$SYSTEM_PARAMETER2" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TABLESPACE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TARGETRBA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TEMPFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TEMPSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TEMP_EXTENT_MAP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TEMP_EXTENT_POOL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TEMP_PING" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TEMP_SPACE_HEADER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$THREAD" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TIMER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TRANSACTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TRANSACTION_ENQUEUE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$TYPE_SIZE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$WAITSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."GV_$_LOCK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."IMP8CDT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."IMP8CON" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."IMP8TTD" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."ORA_KGLR7_OBJECTS" 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"."PLUGGABLE_SET_CHECK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."PROXY_USERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."PS1$" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."PSS1$" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."REPCAT$_CDEF" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."REPCAT_GENERATED" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."REPCAT_REPCAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."REPCAT_REPCATLOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."REPCAT_REPOBJECT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."REPCAT_REPOBJECT_BASE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."REPCAT_REPPROP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."REPCAT_REPSCHEMA" 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"."SM$TS_AVAIL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."SM$TS_FREE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."SM$TS_USED" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."SOURCE_SIZE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."STRADDLING_RS_OBJECTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."STRADDLING_TS_OBJECTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."SYSCATALOG_" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."SYS_DBA_SEGS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."SYS_OBJECTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."SYS_USER_SEGS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."TP$" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."TRUSTED_SERVERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."TSP$" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."TS_PITR_CHECK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."TS_PITR_INFO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."TS_PITR_OBJECTS_TO_BE_DROPPED" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."TS_PLUG_INFO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$ACCESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$AQ" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$AQ1" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$ARCHIVE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$ARCHIVED_LOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$ARCHIVE_DEST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$ARCHIVE_PROCESSES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BACKUP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BACKUP_ASYNC_IO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BACKUP_CORRUPTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BACKUP_DATAFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BACKUP_DEVICE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BACKUP_PIECE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BACKUP_REDOLOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BACKUP_SET" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BACKUP_SYNC_IO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BGPROCESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BSP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BUFFER_POOL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$BUFFER_POOL_STATISTICS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$CIRCUIT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$CLASS_PING" 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_$CONTEXT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$CONTROLFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$CONTROLFILE_RECORD_SECTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$COPY_CORRUPTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DATABASE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DATAFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DATAFILE_COPY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DATAFILE_HEADER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DBFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DBLINK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DB_CACHE_ADVICE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DB_OBJECT_CACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DB_PIPES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DELETED_OBJECT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DISPATCHER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DISPATCHER_RATE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DLM_ALL_LOCKS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DLM_CONVERT_LOCAL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DLM_CONVERT_REMOTE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DLM_LATCH" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DLM_LOCKS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DLM_MISC" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DLM_RESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$DLM_TRAFFIC_CONTROLLER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$ENABLEDPRIVS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$ENQUEUE_LOCK" 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_$FAST_START_SERVERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$FAST_START_TRANSACTIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$FILESTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$FILE_PING" 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_$GLOBAL_BLOCKED_LOCKS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$GLOBAL_TRANSACTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$HS_AGENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$HS_PARAMETER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$HS_SESSION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$INDEXED_FIXED_COLUMN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$INSTANCE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$INSTANCE_RECOVERY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$KCCDI" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$KCCFE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LATCH" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LATCHHOLDER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LATCHNAME" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LATCH_CHILDREN" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LATCH_MISSES" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LATCH_PARENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LIBRARYCACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LICENSE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOCK" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOCKED_OBJECT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOCKS_WITH_COLLISIONS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOCK_ELEMENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOGFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOGHIST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOGMNR_CONTENTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOGMNR_DICTIONARY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOGMNR_LOGS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOGMNR_PARAMETERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$LOG_HISTORY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$MTS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$MYSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$OBJECT_DEPENDENCY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$OBSOLETE_PARAMETER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$OFFLINE_RANGE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$OPEN_CURSOR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PARAMETER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PARAMETER2" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PQ_SLAVE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PQ_SYSSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PROCESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PROXY_ARCHIVEDLOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PROXY_DATAFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PWFILE_USERS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PX_PROCESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PX_PROCESS_SYSSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PX_SESSION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$PX_SESSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$QUEUE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$RECOVERY_FILE_STATUS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$RECOVERY_LOG" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$RECOVERY_PROGRESS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$RECOVERY_STATUS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$RECOVER_FILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$REQDIST" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$RESERVED_WORDS" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$RESOURCE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$RESOURCE_LIMIT" 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_$ROWCACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$ROWCACHE_PARENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$ROWCACHE_SUBORDINATE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SESSION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SESSION_CURSOR_CACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SESSION_EVENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SESSION_OBJECT_CACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SESSION_WAIT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SESSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SESS_IO" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SGA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SGASTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SHARED_POOL_RESERVED" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SHARED_SERVER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SORT_SEGMENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SORT_USAGE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SQL" 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_BIND_DATA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SQL_BIND_METADATA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SQL_CURSOR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SQL_SHARED_CURSOR" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SQL_SHARED_MEMORY" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$STATNAME" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SUBCACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SYSSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SYSTEM_CURSOR_CACHE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SYSTEM_EVENT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SYSTEM_PARAMETER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$SYSTEM_PARAMETER2" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TABLESPACE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TARGETRBA" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TEMPFILE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TEMPSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TEMP_EXTENT_MAP" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TEMP_EXTENT_POOL" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TEMP_PING" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TEMP_SPACE_HEADER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$THREAD" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TIMER" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TRANSACTION" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TRANSACTION_ENQUEUE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$TYPE_SIZE" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$WAITSTAT" TO SELECT_CATALOG_ROLE;
GRANT SELECT ON  "SYS"."V_$_LOCK" TO SELECT_CATALOG_ROLE;
GRANT "HS_ADMIN_ROLE;" TO SELECT_CATALOG_ROLE;

It’s used here ONLY to illustrate the issue and the possible solutions]:

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
asdfjkl

SQL>

Since a public synonym exists in every Oracle database for the V$INSTANCE view all that was necessary was to grant select privileges on either the V$INSTANCE view alone or grant the user the SELECT_CATALOG_ROLE (as we did here). Voila! Instant access!

But, what if our user is granted the necessary access and STILL gets the obnoxious ORA-00942 error? Let’s look at a relatively obscure SYS view that SELECT_CATALOG_ROLE provides access to:

SQL> select * from ku$_index_view;
select * from ku$_index_view
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>

Gee, we can’t find that view by name, at least. We know SYS owns it, so let’s see if using a qualified name makes a difference:

SQL> select * from sys.ku$_index_view;

[oodles and scads of data returned]

SQL>

It does, so, darn, it must be a missing synonym … let’s fix that problem:

SQL> create synonym ku$_index_view for sys.ku$_index_view;

Synonym created.

SQL>SQL> select * from ku$_index_view;

[oodles and scads of data returned]

SQL>

So, we see that it could be one of three issues causing an ORA-00942 error:

* The OBVIOUS reason: no table or view by that name exists in the database (but you know otherwise which brought you here)

* Less obvious: you have no select privileges on that table/view

* Even less obvious: a synonym for that table/view doesn’t exist presuming you do have privileges on the table/view

You can discover if you do have privileges on a table not in your schema by querying the ALL_TABLES view; a similar query can be run against ALL_VIEWS to see the same information on views not owned by you. If the table or view is listed, but access by name fails, you need a synonym created.

Hopefully this discussion has provided the tools necessary to investigate the situation when this error arises, and can provide information to supply to the DBA so he/she can either:

Tell you why such access isn’t allowed for non-DBA users, or

Allow he/she to grant the necessary privileges and create the necessary synonyms so you can have access.

Not every user is destined to access every table or view in an Oracle database, but when one non-DBA user can access a catalog table/view that you cannot you can determine what is missing and inform your DBA or manager (you really want to follow the chain of command with such issues). Oh, and the same problems can plague access to application tables/views, so you may need to contact your application support person to obtain access (presuming, again, that no sensitive information is contained in those tables/views).

Suffice it to say this can be a ‘hot button’ in some organizations, so follow the chain of command when making such access requests, no matter what table or view you feel you need privileges on. There may be valid reasons why you aren’t allowed to see that particular data.

Now, get back to work. đŸ˜€

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: