Home » RDBMS Server » Security » Verifying database role
Verifying database role [message #2063] Wed, 19 June 2002 13:49 Go to next message
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.
Re: Verifying database role [message #2065 is a reply to message #2063] Wed, 19 June 2002 14:19 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
select *
  from dba_role_privs
 where grantee = 'SOMEUSER'
   and granted_role = 'SOMEROLE';
Re: Verifying database role [message #2074 is a reply to message #2065] Wed, 19 June 2002 21:54 Go to previous message
Maaher
Messages: 7064
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
Previous Topic: column level security :
Next Topic: Grant object privileges to a role on other schema objects
Goto Forum:
  


Current Time: Thu May 26 16:15:40 CDT 2022