Home » SQL & PL/SQL » SQL & PL/SQL » To know privileges under each role
To know privileges under each role [message #267040] Wed, 12 September 2007 06:02 Go to next message
donind
Messages: 95
Registered: February 2007
Member
Hi,

Which table we have to querry to the know the privileges assigned to under each role.

Thanks in advance
Re: To know privileges under each role [message #267042 is a reply to message #267040] Wed, 12 September 2007 06:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS

Regards
Michel
Re: To know privileges under each role [message #267045 is a reply to message #267042] Wed, 12 September 2007 06:16 Go to previous message
donind
Messages: 95
Registered: February 2007
Member
Thanks for solution

[mod-edit] removed illiterate IM words.

[Updated on: Wed, 12 September 2007 07:45] by Moderator

Report message to a moderator

Previous Topic: Privileges create any table
Next Topic: Multiset union error
Goto Forum:
  


Current Time: Sun Dec 04 14:50:52 CST 2016

Total time taken to generate the page: 0.10430 seconds