Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

B28320-03
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, or EDITIONS_ENABLED 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)   Indicates whether the user is authenticated by OID (GLOBAL) or externally authenticated (EXTERNAL); NULL otherwise
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)   Database version in which the password was created or changed
EDITIONS_ENABLED VARCHAR2(1)   Reserved for future use

See Also:

"USER_USERS"