5.289 DBA_ROLES

DBA_ROLES describes all roles in the database.

Column	Datatype	NULL	Description
ROLE	VARCHAR2(128)	NOT NULL	Name of the role
ROLE_ID	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.
INHERITED	VARCHAR2(3)		Indicates whether the role was inherited from another container (YES) or not (NO)
IMPLICIT	VARCHAR2(3)		Indicates whether the role is a common role created by an implicit application (YES) or not (NO)
EXTERNAL_NAMEFoot 1	VARCHAR2(4000)		For a global role, the external name refers to the DN of a group from a directory service that is mapped to the global role. This is not applicable to a local role.

^Footnote 1 This column is available starting with Oracle Database release 18c, version 18.1.