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