Objects Privileges Granted to a ROLE
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
0