DBA_ROLE_PRIVS

Purpose

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

Columns

Sample query

• Query the roles granted to user USER2.

  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
  

• Query the roles granted to role ROLE1.

  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