The DBA_USERS view provides the information about all users of the database.

Parameter Type Description
username TEXT The username of the user.
user_id OID The ID number of the user.
password CHARACTER VARYING(30) The encrypted password of the user.
account_status CHARACTER VARYING(32) The current status of the account. Valid values:
  • OPEN
  • EXPIRED
  • EXPIRED(GRACE)
  • EXPIRED & LOCKED
  • EXPIRED & LOCKED(TIMED)
  • EXPIRED(GRACE) & LOCKED
  • EXPIRED(GRACE) & LOCKED(TIMED)
  • LOCKED
  • LOCKED(TIMED)
lock_date TIMESTAMP WITHOUT TIME ZONE If the account status is LOCKED, the lock_date parameter indicates the date and time when the account was locked.
expiry_date TIMESTAMP WITHOUT TIME ZONE The expiration date of the password.
default_tablespace TEXT The default tablespace associated with the account.
temporary_tablespace CHARACTER VARYING(30) This parameter is supported for compatibility only. The value is '' (an empty string).
created TIMESTAMP WITHOUT TIME ZONE This parameter is supported for compatibility only. The value is NULL.
profile CHARACTER VARYING(30) The profile associated with the user.
initial_rsrc_consumer_group CHARACTER VARYING(30) This parameter is supported for compatibility only. The value is NULL.
external_name CHARACTER VARYING(4000) This parameter is supported for compatibility only. The value is NULL.