Skip to Main Content

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!

Metadata view to fetch the Privileges granted to a Role

848959Oct 19 2011 — edited Oct 19 2011
Hi,

I have a doubt in Roles metadata view, please provide me more details on the same.

In dba_roles view, I could see the list of Roles and in dba_role_privs view, I could see the list of users who has been granted this role.

Now, I would like to identify the list of Privileges granted to this Role. From which metadata view I could find this information, please help.
Thank you.
This post has been answered by 584412 on Oct 19 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2011
Added on Oct 19 2011
3 comments
296 views