Database Security Products (MOSC)

MOSC Banner

Objects Privileges Granted to a ROLE

edited Oct 9, 2012 4:28AM in Database Security Products (MOSC) 4 commentsAnswered
Hi All;i need to help to write a query . i wan to have a view that can tell me all the objects name to whom a ROLE have any privilege. we can use role_tab_privs but it just gives tables information not other objects like package, procedures etc etc. so pl help me in this how i can get complete list of objects on which a ROLE have privilege.thanks alot

  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center