ROLE

VARCHAR2(128)

NOT NULL

Name of the role

ROLE_ID

NUMBER

NOT NULL

ID number of the role

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

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.

INHERITED

VARCHAR2(3)

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

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

IMPLICIT

VARCHAR2(3)

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

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