EXA_DBA_ROLE_PRIVS

The system table shows a list of all roles granted to a user or a role. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Name Description
GRANTEE Name of user or role who has been granted the right to adopt GRANTED_ROLE
GRANTED_ROLE Name of role that was granted
ADMIN_OPTION Specifies whether GRANTEE is allowed to grant the right to the role to other users or roles