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

E40402-08
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_USERS

DBA_USERS describes all users of the database.

Related View

USER_USERS describes the current user. This view does not display the PASSWORD, PROFILE, PASSWORD_VERSIONS, EDITIONS_ENABLED, or AUTHENTICATION_TYPE columns.

Column Datatype NULL Description
USERNAME VARCHAR2(30) NOT NULL Name of the user
USER_ID NUMBER NOT NULL ID number of the user
PASSWORD VARCHAR2(30)   This column is deprecated in favor of the AUTHENTICATION_TYPE column
ACCOUNT_STATUS VARCHAR2(32) NOT NULL Account status:
  • OPEN

  • EXPIRED

  • EXPIRED(GRACE)

  • LOCKED(TIMED)

  • LOCKED

  • EXPIRED & LOCKED(TIMED)

  • EXPIRED(GRACE) & LOCKED(TIMED)

  • EXPIRED & LOCKED

  • EXPIRED(GRACE) & LOCKED

LOCK_DATE DATE   Date the account was locked if account status was LOCKED
EXPIRY_DATE DATE   Date of expiration of the account
DEFAULT_TABLESPACE VARCHAR2(30) NOT NULL Default tablespace for data
TEMPORARY_TABLESPACE VARCHAR2(30) NOT NULL Name of the default tablespace for temporary tables or the name of a tablespace group
CREATED DATE NOT NULL User creation date
PROFILE VARCHAR2(30) NOT NULL User resource profile name
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)   Initial resource consumer group for the user
EXTERNAL_NAME VARCHAR2(4000)   User external name
PASSWORD_VERSIONS VARCHAR2(8)   Shows the list of versions of the password hashes (also known as "verifiers") existing for the account.

The PASSWORD_VERSIONS column value includes 10G if an old case-insensitive ORCL hash exists and 11G if a SHA-1 hash exists.

Note that one or both of these verifiers can exist for any given account.

EDITIONS_ENABLED VARCHAR2(1)   Indicates whether editions have been enabled for the corresponding user (Y) or not (N)
AUTHENTICATION_TYPE VARCHAR2(8)   Indicates the authentication mechanism for the user:
  • EXTERNAL - CREATE USER user1 IDENTIFIED EXTERNALLY;

  • GLOBAL - CREATE USER user2 IDENTIFIED GLOBALLY;

  • PASSWORD - CREATE USER user3 IDENTIFIED BY user3;


See Also:

"USER_USERS"