Home » RDBMS Server » Security » how to identifies list of roles (oracle 9i , widows xp)
icon11.gif  how to identifies list of roles [message #290437] Fri, 28 December 2007 21:03 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi Guru,

I want to know how many roles are availble.

If any command to know that list.

please do needful.


Thank in advance

Regards
Kanish
Re: how to identifies list of roles [message #290441 is a reply to message #290437] Fri, 28 December 2007 21:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
DBA_ROLES.
Re: how to identifies list of roles [message #294354 is a reply to message #290437] Thu, 17 January 2008 05:38 Go to previous messageGo to next message
parthokonar
Messages: 17
Registered: September 2006
Location: india
Junior Member
yes dba_roles will give all the roles present in the database and if you want to see how many roles are granted / present for a particular user -
then go for dba_role_privs where grantee = 'USER';
Re: how to identifies list of roles [message #294360 is a reply to message #294354] Thu, 17 January 2008 05:47 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If OP is not able to build the query when we give him the view, I don't think he is able to do anything in the database. Wink

Regards
Michel
Previous Topic: how to assign a same to role another person
Next Topic: sys dba authentication
Goto Forum:
  


Current Time: Thu Dec 08 22:16:00 CST 2016

Total time taken to generate the page: 0.11429 seconds