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.
|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.|