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:
|
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. |