Feature
DBA_USERS lists all users in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_USERS
Fields
| Field | 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. Valid values:
|
| 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. |
| CREATED | DATE | NO | The user creation date. |
| 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. |