The DBA_ROLE_PRIVS view provides the information on all roles that have been granted to users. A row is created for each role to which a user has been granted.

Parameter Type Description
grantee TEXT The username to whom the role is granted.
granted_role TEXT The name of the role granted to the grantee.
admin_option TEXT YES: indicates that the role is granted with the admin option. NO: indicates that the role is granted with the other options other than admin.
default_role TEXT YES: indicates that the role is enabled when the grantee creates a session.