DBA_ROLE_PRIVS

Roles granted to users and roles

Columns
___________________________
GRANTEE
Grantee Name,User or Role receiving the grant
GRANTED_ROLE
Granted role name
ADMIN_OPTION
Grant was with the ADMIN option
DEFAULT_ROLE
Role is designated as a DEFAULT ROLE for the user