OraFAQ Forum: Security » Verifying database role

Home » RDBMS Server » Security » Verifying database role

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

Verifying database role [message #2063]

Wed, 19 June 2002 13:49

Johnny Whiplash
Messages: 7
Registered: May 2002

Junior Member

Can I verify if I my user has been granted a database role using SQL Plus? And if so what query should I run to verify this. Thanks.

Report message to a moderator

Re: Verifying database role [message #2065 is a reply to message #2063]

Wed, 19 June 2002 14:19

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Code: [Select all] [Show/ hide]

select *
  from dba_role_privs
 where grantee = 'SOMEUSER'
   and granted_role = 'SOMEROLE';

Report message to a moderator

Re: Verifying database role [message #2074 is a reply to message #2065]

Wed, 19 June 2002 21:54

Maaher
Messages: 7065
Registered: December 2001

Senior Member

And via role_tab_privs,role_sys_privs and role_role_privs, you can see what is within these roles that are granted to SOMEUSER. Sometimes a role is granted to another role , and the latter is granted to the user. So in this case, you wouldn't see the first role appear in dba_role_privs.

MHE

Report message to a moderator

Previous Topic:	column level security :
Next Topic:	Grant object privileges to a role on other schema objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 15:52:56 CDT 2025