Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

Are there any tables that I can get all Oracle supported system privileges and object privileges? I know there is a view called all_sys_privs in Oracle. But I can't find more information about it.

Thanks.

share|improve this question
dba_sys_privs? – Jack Douglas♦ Aug 29 '11 at 8:31
DBA_SYS_PRIVS describes system privileges granted to users and roles. What I need is all the privileges names that Oracle support. – Yousui Aug 29 '11 at 8:41
so would all_sys_privs if it existed – Jack Douglas♦ Aug 29 '11 at 8:59

1 Answer

up vote 5 down vote accepted

Perhaps you are looking for SYSTEM_PRIVILEGE_MAP?

share|improve this answer
Yes, it's this view. How about all object privileges? – Yousui Aug 29 '11 at 9:18
If you want a list of all possible object privileges, you will have to construct it from dba_objects – Jack Douglas♦ Aug 29 '11 at 9:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.