OraFAQ Forum: Security » how to identifies list of roles

Home » RDBMS Server » Security » how to identifies list of roles (oracle 9i , widows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to identifies list of roles [message #290437]

Fri, 28 December 2007 21:03

mm_kanish05
Messages: 488
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

Report message to a moderator

Re: how to identifies list of roles [message #290441 is a reply to message #290437]

Fri, 28 December 2007 21:50

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

DBA_ROLES.

Report message to a moderator

Re: how to identifies list of roles [message #294354 is a reply to message #290437]

Thu, 17 January 2008 05:38

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';

Report message to a moderator

Re: how to identifies list of roles [message #294360 is a reply to message #294354]

Thu, 17 January 2008 05:47

Michel Cadot
Messages: 68166
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

Report message to a moderator

Previous Topic:	how to assign a same to role another person
Next Topic:	sys dba authentication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 22 17:31:47 CDT 2022