Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_ROLES

DBA_ROLES describes all roles in the database.

Column Datatype NULL Description
ROLE VARCHAR2(128) NOT NULL Name 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.