5.282 DBA_ROLES

DBA_ROLES describes all roles in the database.

Column Datatype NULL Description

ROLE

VARCHAR2(128)

NOT NULL

Name of the role

ROLE_IDFoot 1

NUMBER

NOT NULL

ID number of the role

PASSWORD_REQUIRED

VARCHAR2(8)

This column is deprecated in favor of the AUTHENTICATION_TYPE column

AUTHENTICATION_TYPE

VARCHAR2(11)

Indicates the authentication mechanism for the role:

  • NONE - CREATE ROLE role1;

  • EXTERNAL - CREATE ROLE role2 IDENTIFIED EXTERNALLY;

  • GLOBAL - CREATE ROLE role3 IDENTIFIED GLOBALLY;

  • APPLICATION - CREATE ROLE role4 IDENTIFIED USING schema.package;

  • PASSWORD - CREATE ROLE role5 IDENTIFIED BY role5;

COMMON

VARCHAR2(3)

Indicates whether a given role is common. Possible values:

  • YES if the role is common

  • NO if the role is local (not common)

ORACLE_MAINTAINED

VARCHAR2(1)

Denotes whether the role was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql). A role for which this column has the value Y must not be changed in any way except by running an Oracle-supplied script.

INHERITEDFootref 1

VARCHAR2(3)

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

IMPLICITFootref 1

VARCHAR2(3)

Indicates whether the role is a common role created by an implicit application (YES) or not (NO)

Footnote 1

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