Monday, September 13, 2010

What is difference between SELECT_CATALOG_ROLE, SELECT ANY DICTIONARY and SELECT ANY TABLE?

SELECT ANY TABLE is system privilege and provide access to all users tables except SYS.
SELECT_CATALOG_ROLE is role which provides access to all SYS views (dba%, v$%).

SELECT ANY DICTIONARY is system privilege and provide access to SYS schema objects only.It must be granted individually to each user requiring the privilege.

No comments:

Post a Comment