Static Data Dictionary Views, 216 of 452
DBA_ROLE_PRIVS lists roles granted to users and roles.
DBA_ROLE_PRIVS
GRANTEE
VARCHAR2(30)
Grantee name, user or role receiving the grant
GRANTED_ROLE
NOT NULL
Granted role name
ADMIN_OPTION
VARCHAR2(3)
Whether the grant was with the ADMIN option: YES | NO
YES
NO
DEFAULT_ROLE
Whether the role is designated as a DEFAULT ROLE for the user: YES | NO