List Oracle Roles Granted to a User
Posted: Mon Jan 30, 2012 10:25 pm
To show what roles are granted to a user, use the below script.
select GRANTEE, GRANTED_ROLE, DEFAULT_ROLE from dba_role_privs where GRANTEE ='&Grantee';
Sample Output:
select GRANTEE, GRANTED_ROLE, DEFAULT_ROLE from dba_role_privs where GRANTEE ='&Grantee';
Sample Output:
Code: Select all
GRANTEE GRANTED_ROLE DEF
------------------------------ ------------------------------ ---
SCOTT RESOURCE YES
SCOTT CONNECT YES