Oracle role: SELECT_CATALOG_ROLE

SELECT_CATALOG_ROLE is an Oracle maintained role.

This role is required (among others?)

• to use dbms_metadata to extract definitions from another schema.

The V_$ synonyms are granted SELECT_CATALOG_ROLE in $ORACLE_HOME/rdbms/amdin/cdfixed.sql.