SYS.DBA_USERS

The DBA_USERS view describes all users of the database.

Related views

Columns

Column name Type Description.

USERNAME

VARCHAR2(30) INLINE

Name of the user

USER_ID

TT_INTEGER NOT NULL

ID number of the user

PASSWORD

VARCHAR2(30) INLINE

Value NULL

ACCOUNT_STATUS

VARCHAR2(32) INLINE NOT NULL

Indicates the status of the account. The mapping for the ACCOUNT_STATUS column is derived from the USER_ASTATUS_MAP table. Example: OPEN

Command> SELECT * 
         FROM 
         USER_
         ASTATUS_
         MAP;
< 0, OPEN >
< 1, EXPIRED >
< 2, EXPIRED
    (GRACE) >
< 4, LOCKED(TIMED) >
< 8, LOCKED >
< 5, EXPIRED & 
     LOCKED(TIMED) >
< 6, EXPIRED(GRACE)
     & LOCKED(TIMED)
     >
< 9, EXPIRED & 
     LOCKED >
< 10, EXPIRED(GRACE)
      & LOCKED >
9 rows found.

LOCK_DATE

TT_TIMESTAMP

The time when the account was locked. If the account is not locked, the value is NULL.

EXPIRY_DATE

TT_TIMESTAMP

The actual expiry date of the password. This is calculated as (the time the user logs in after the password expires and falls in the grace period) plus (the grace period). If there is no expiry date, the value is NULL.

DEFAULT_TABLESPACE

VARCHAR2(30) INLINE NOT NULL

Value USERS

TEMPORARY_TABLESPACE

VARCHAR2(30) INLINE NOT NULL

Value TEMP

CREATED

TT_TIMESTAMP NOT NULL

Date when the user was created

PROFILE

VARCHAR2 (30) INLINE NOT NULL

Name of the profile. If there is no profile assigned, the value is DEFAULT.

INITIAL_RSRC_CONSUMER_GROUP

VARCHAR2(30) INLINE

Value NULL

EXTERNAL_NAME

VARCHAR2(4000) NOT INLINE

Value NULL

PASSWORD_VERSIONS

VARCHAR2(8) INLINE

Value NULL

EDITIONS_ENABLED

VARCHAR2(1) INLINE

Value NULL