The USER_USERS view provides the information about the current user.

Parameter Type Description
username TEXT The username of the user.
user_id OID The ID 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 set to LOCKED, the lock_date parameter displays the date and time when the account is locked
expiry_date TIMESTAMP WITHOUT TIME ZONE The expiration date of the account.
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.
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.