DBA_USERS v11
The DBA_USERS view provides information about all users of the database.
| Name | Type | Description |
|---|---|---|
username | TEXT | User name of the user. |
user_id | OID | ID number of the user. |
password | CHARACTER VARYING(30) | The password (encrypted) of the user. |
account_status | CHARACTER VARYING(32) | The current status of the account. Possible values are: OPEN, EXPIRED, EXPIRED(GRACE), EXPIRED & LOCKED, EXPIRED & LOCKED(TIMED), EXPIRED(GRACE) & LOCKED, EXPIRED(GRACE) & LOCKED(TIMED), LOCKED, LOCKED(TIMED). Use the edb_get_role_status(role_id) function to get the current status of the account. |
lock_date | TIMESTAMP WITHOUT TIME ZONE | If the account status is LOCKED, lock_date displays the date and time the account was locked. |
expiry_date | TIMESTAMP WITHOUT TIME ZONE | The expiration date of the password. Use the edb_get_password_expiry_date(role_id) function to get the current password expiration date. |
default_tablespace | TEXT | The default tablespace associated with the account. |
temporary_tablespace | CHARACTER VARYING(30) | Included for compatibility only. The value will always be '' (an empty string). |
created | TIMESTAMP WITHOUT TIME ZONE | Included 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) | Included for compatibility only. The value is always NULL. |
external_name | CHARACTER VARYING(4000) | Included for compatibility only. The value is always NULL. |