Note
This view is introduced since OceanBase Database V4.2.1 BP2.
Purpose
The USER_USERS view displays information about the current user.
Applicability
This view applies only to OceanBase Database Enterprise Edition.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| USERNAME | VARCHAR2(128) | No | The username. |
| USERID | NUMBER(38) | No | The ID of the user. |
| ACCOUNT_STATUS | VARCHAR2(32) | No | The account status. Valid values:
|
| LOCK_DATE | DATE | No | The date when the account 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 or tablespace group for temporary tables. |
| LOCAL_TEMP_TABLESPACE | VARCHAR2(30) | No | The name of the local temporary tablespace. |
| 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. |
| PROXY_ONLY_CONNECT | VARCHAR2(1) | No | Indicates whether to connect to the database only through a proxy user. |
| COMMON | VARCHAR2(3) | No | Indicates whether the user is a common user. |
| ORACLE_MAINTAINED | VARCHAR2(1) | No | Indicates whether the system object, such as a user, table, view, or procedure, is created and maintained by the script in Oracle mode. |
| INHERITED | VARCHAR2(3) | No | Indicates whether the user is inherited from another container. |
| DEFAULT_COLLATION | VARCHAR2(100) | No | The default character set. |
| IMPLICIT | VARCHAR2(3) | No | Indicates whether the user is created by an implicit application. |
| ALL_SHARD | VARCHAR2(3) | No | Indicates whether the user is created with sharding enabled. |
| PASSWORD_CHANGE_DATE | DATE | Yes | The time of the last password change. |
Example
obclient> SELECT * FROM SYS.USER_USERS\G
The query result is as follows:
*************************** 1. row ***************************
USERNAME: SYS
USERID: 200003
ACCOUNT_STATUS: OPEN
LOCK_DATE: NULL
EXPIRY_DATE: NULL
DEFAULT_TABLESPACE: NULL
TEMPORARY_TABLESPACE: NULL
LOCAL_TEMP_TABLESPACE: NULL
CREATED: 29-NOV-23
INITIAL_RSRC_CONSUMER_GROUP: NULL
EXTERNAL_NAME: NULL
PROXY_ONLY_CONNECT: N
COMMON: No
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)