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.
|
|
|
|
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
|
|
|