Purpose
The DBA_USERS view displays all users in the database.
Applicability
This view applies only to the Oracle mode of OceanBase Database.
Columns
| Column | Type | Nullable? | Description | |||||
|---|---|---|---|---|---|---|---|---|
| USERNAME | VARCHAR2(128) | NO | The username. | |||||
| USER_ID | NUMBER(38) | NO | The ID of the user. | |||||
| PASSWORD | VARCHAR2(128) | NO | We recommend that you do not use value of the AUTHENTICATION_TYPE column for this column. |
|||||
| ACCOUNT_STATUS | VARCHAR2(30) | NO | The account status.
|
LOCK_DATE | DATE | NO | The date when the account was locked if the account status was LOCKED. |
|
| EXPIRY_DATE | DATE | NO | The date of expiration of the account. | |||||
| DEFAULT_TABLESPACE | VARCHAR2(30) | NO | The default tablespace for data. | |||||
| TEMPORARY_TABLESPACE | VARCHAR2(30) | NO | The name of the default tablespace for temporary tables or the name of a tablespace group. | |||||
| LOCAL_TEMP_TABLESPACE | VARCHAR2(30) | NO | The local temporary tablespace.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| CREATED | DATE | NO | The user creation date. | |||||
| PROFILE | VARCHAR2(128) | NO | The name of the user resource configuration file.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| INITIAL_RSRC_CONSUMER_GROUP | VARCHAR2(30) | NO | The initial resource consumer group for the user. | |||||
| EXTERNAL_NAME | VARCHAR2(4000) | NO | The external username of the user. | |||||
| PASSWORD_VERSIONS | VARCHAR2(12) | NO | The version of the password hashing algorithm.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| EDITIONS_ENABLED | VARCHAR2(1) | NO | Whether editions are enabled for the user.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| AUTHENTICATION_TYPE | VARCHAR2(8) | NO | The mechanism for user authentication.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| PROXY_ONLY_CONNECT | VARCHAR2(1) | NO | Whether can only connect through proxy user.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| COMMON | VARCHAR2(3) | NO | Whether it is a common user.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| LAST_LOGIN | TIMESTAMP(9) WITH TIME ZONE | NO | The time of the last user logon.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| ORACLE_MAINTAINED | VARCHAR2(1) | NO | Whether an object is created and maintained by scripts provided by the Oracle mode.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| INHERITED | VARCHAR2(3) | NO | Whether the user is inherited from another container.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| DEFAULT_COLLATION | VARCHAR2(100) | NO | The default character set.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| IMPLICIT | VARCHAR2(3) | NO | Whether the user is created by an implicit application.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| ALL_SHARD | VARCHAR2(3) | NO | Whether an object is created with sharding enabled.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
| PASSWORD_CHANGE_DATE | DATE | YES | The time when the password was changed last time.
NoteThis column is introduced in V4.2.1 BP2. |
|||||
Example
obclient> SELECT * FROM SYS.DBA_USERS\G
The query result is as follows:
*************************** 1. row ***************************
USERNAME: SYS
USERID: 200003
PASSWORD: ******
ACCOUNT_STATUS: OPEN
LOCK_DATE: NULL
EXPIRY_DATE: NULL
DEFAULT_TABLESPACE: NULL
TEMPORARY_TABLESPACE: NULL
LOCAL_TEMP_TABLESPACE: NULL
CREATED: 29-NOV-23
PROFILE: DEFAULT
INITIAL_RSRC_CONSUMER_GROUP: NULL
EXTERNAL_NAME: NULL
PASSWORD_VERSIONS: NULL
EDITIONS_ENABLED: N
AUTHENTICATION_TYPE: PASSWORD
PROXY_ONLY_CONNECT: N
COMMON: NO
LAST_LOGIN: NULL
ORACLE_MAINTAINED: N
INHERITED: NO
DEFAULT_COLLATION: USING_NLS_COMP
IMPLICIT: NO
ALL_SHARD: NO
PASSWORD_CHANGE_DATE: 29-NOV-23
1 row in set (0.001 sec)