Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

table privileges granted to roles [ROLE_TAB_PRIVS]

CinkoJan 11 2013 — edited Jan 11 2013
Hello,

i am trying to fetch all roles, table_name and privilege using table ROLE_TAB_PRIVS.

BI went to check which roles are displayed in that table and it says:

Information is provided only about roles to which the user has access.

Here is my problem ... i can not find some of the roles that are 100% created ... i have tried even with sys user but still no success.

Is there a way to query all roles created in DB with table_names & privileges?

Thank you in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2013
Added on Jan 11 2013
2 comments
1,871 views