The USER_USERS view returns information about the current user's account, including account status, lock date, expiry date, and the associated default tablespace.
| Column | Type | Description |
|---|---|---|
username | TEXT | The username of the current user. |
user_id | OID | The ID of the current user. |
account_status | CHARACTER VARYING(32) | The current status of the account. For valid values, see Account status values. |
lock_date | TIMESTAMP WITHOUT TIME ZONE | The date and time the account was locked. Populated only when account_status 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) | Included for compatibility only. Always returns '' (an empty string). |
created | TIMESTAMP WITHOUT TIME ZONE | Included for compatibility only. Always returns NULL. |
initial_rsrc_consumer_group | CHARACTER VARYING(30) | Included for compatibility only. Always returns NULL. |
external_name | CHARACTER VARYING(4000) | Included for compatibility only. Always returns NULL. |
Account status values
The account_status column returns one of the following values:
| Value |
|---|
OPEN |
EXPIRED |
EXPIRED(GRACE) |
EXPIRED & LOCKED |
EXPIRED & LOCKED(TIMED) |
EXPIRED(GRACE) & LOCKED |
EXPIRED(GRACE) & LOCKED(TIMED) |
LOCKED |
LOCKED(TIMED) |