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

Name Type Description
username TEXT The username.
user_id OID The ID.
password CHARACTER VARYING(30) The encrypted password.
account_status CHARACTER VARYING(32) The current state 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 state is LOCKED, the lock_date parameter specifies 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 provided for compatibility only. The value is always '' (an empty string).
created TIMESTAMP WITHOUT TIME ZONE This parameter is provided for compatibility only. The value is always NULL.
profile CHARACTER VARYING(30) The profile associated with the user.
initial_rsrc_consumer_group CHARACTER VARYING(30) This parameter is provided for compatibility only. The value is always NULL.
external_name CHARACTER VARYING(4000) This parameter is provided for compatibility only. The value is always NULL.