Accessing Frequently Used Dictionary Objects

Users with explicit object privileges and the SYSDBA can access dictionary
objects. If, however, you need access to dictionary objects and do not have
explicit object privileges, you can be granted the following roles:
* SELECT_CATALOG_ROLE
Enables users to SELECT all exported catalog views and tables granted to
this role. Grant this role to users who must access all exported views and
tables in the data dictionary.
* EXECUTE_CATALOG_ROLE
Provides EXECUTE privilege on exported packages in the dictionary.
* DELETE_CATALOG_ROLE
Enables users to delete records from the AUD$ table.
These roles enable database administrators to access certain objects in the
dictionary while maintaining dictionary security.[@more@]