Oracle

ORACLE

what is difference between SELECT ANY dictionary and SELECT_CATALOG_ROLE ?

SELECT_CATALOG_ROLE is more restrictive than SELECT ANY DICTIONARY. Although both have privileges to select from the dictionary views, SELECT ANY DICTIONARY allows the user to see the source code of package bodies and triggers which are normally available to the DBAs. SELECT ANY DICTIONARY is a system privilege, while SELECT_CATALOG_ROLE is a role. SELECT_CATALOG_ROLE allows…

Srikanth Kumar Sridhara's avatar by Srikanth Kumar Sridhara

Something went wrong. Please refresh the page and/or try again.

Leave a comment