1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. ROLE_ROLE_PRIVS

6.239 ROLE_ROLE_PRIVS

ROLE_ROLE_PRIVS describes the roles granted to other roles.

Information is provided only about roles to which the user has access.

Column Datatype NULL Description

ROLE

VARCHAR2(128)

Name of the role

GRANTED_ROLE

VARCHAR2(128)

Role that was granted

ADMIN_OPTION

VARCHAR2(3)

Signifies that the role was granted with ADMIN option

COMMON

VARCHAR2(3)

Indicates how the grant was made. Possible values:

  • YES if the role was granted commonly (CONTAINER=ALL was used)

  • NO if the role was granted locally (CONTAINER=ALL was not used)

INHERITED

VARCHAR2(3)

Indicates whether the role grant was inherited from another container (YES) or not (NO)

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).