dba_role_privs
Name Null? Type
---------------- -------- ------------
GRANTEE VARCHAR2(30)
GRANTED_ROLE NOT NULL VARCHAR2(30)
ADMIN_OPTION VARCHAR2(3)
DEFAULT_ROLE VARCHAR2(3)
Information about roles that have been granted. To see what roles have been granted to a user run this:
select grantee
, granted_role
, admin_option
from dba_role_privs
where grantee like upper('&username')
/
The output will look something like this:
GRANTEE GRANTED_ROLE ADMIN
---------------- --------------------- -----
ANDY CONNECT NO
ANDY RESOURCE NO
The admin column shows whether or not the grantee is able to grant the role to others.
For more useful DBA queries click here.
| 