DBA_ROLE_PRIVS

Purpose

This view describes the roles granted to all users and the roles in the database.

Columns

Sample query

• View the roles owned by the USER2 user.

  obclient [SYS]> SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE ='USER2';
  

  The query result is as follows:

  +---------+--------------+--------------+--------------+
  | GRANTEE | GRANTED_ROLE | ADMIN_OPTION | DEFAULT_ROLE |
  +---------+--------------+--------------+--------------+
  | USER2   | ROLE1        | NO           | YES          |
  +---------+--------------+--------------+--------------+
  1 row in set
  

• View the roles owned by the ROLE1 role.

  obclient [SYS]> SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE ='ROLE1';
  

  The query result is as follows:

  +---------+--------------+--------------+--------------+
  | GRANTEE | GRANTED_ROLE | ADMIN_OPTION | DEFAULT_ROLE |
  +---------+--------------+--------------+--------------+
  | ROLE1   | ROLE2        | NO           | YES          |
  +---------+--------------+--------------+--------------+
  1 row in set
  

References

USER_ROLE_PRIVS