Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
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(30) 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;