Purpose
The oceanbase.DBA_OB_USERS view displays all information about the current tenant.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| USER_NAME | varchar(128) | NO | The name of the tenant. |
| HOST | varchar(128) | NO | The name of the server. |
| PASSWD | varchar(128) | NO | The password of the tenant. |
| INFO | varchar(4096) | NO | The tenant information. |
| PRIV_ALTER | varchar(3) | NO | The privilege to modify databases or tables. |
| PRIV_CREATE | varchar(3) | NO | The privilege to create databases or tables. |
| PRIV_DELETE | varchar(3) | NO | The privilege to delete database or table records. |
| PRIV_DROP | varchar(3) | NO | The privilege to drop databases or tables. |
| PRIV_GRANT_OPTION | varchar(3) | NO | The privileges granted to the current tenant. |
| PRIV_INSERT | varchar(3) | NO | The privilege to insert records. |
| PRIV_UPDATE | varchar(3) | NO | The privilege to update records. |
| PRIV_SELECT | varchar(3) | NO | The privilege to query records. |
| PRIV_INDEX | varchar(3) | NO | The privilege to set indexes. |
| PRIV_CREATE_VIEW | varchar(3) | NO | The privilege to create views. |
| PRIV_SHOW_VIEW | varchar(3) | NO | The privilege to query views. |
| PRIV_SHOW_DB | varchar(3) | NO | The privilege to query all databases. |
| PRIV_CREATE_USER | varchar(3) | NO | The privilege to create tenants. |
| PRIV_SUPER | varchar(3) | NO | The super tenant privileges. |
| IS_LOCKED | varchar(3) | NO | The privilege to lock tables. |
| PRIV_PROCESS | varchar(3) | NO | The privilege to view all threads. |
| PRIV_CREATE_SYNONYM | varchar(3) | NO | The privilege to create synonyms. |
| SSL_TYPE | bigint(20) | NO | The security type of Security Socket Layer (SSL) encryption. |
| SSL_CIPHER | varchar(1024) | NO | The security password for SSL encryption. |
| X509_ISSUER | varchar(1024) | NO | The name of the X.509 certificate issuer. |
| X509_SUBJECT | varchar(1024) | NO | The name of the subject of the X.509 certificate. |
| TYPE | varchar(4) | NO | The type. |
| PROFILE_ID | bigint(20) | NO | The document ID. |
| PASSWORD_LAST_CHANGED | timestamp(6) | YES | The time when the password was last changed. |
| PRIV_FILE | varchar(3) | NO | The privilege to view files. |
| PRIV_ALTER_TENANT | varchar(3) | NO | The privilege to modify tenant information. |
| PRIV_ALTER_SYSTEM | varchar(3) | NO | The privilege to modify server configuration parameters. |
| PRIV_CREATE_RESOURCE_POOL | varchar(3) | NO | The privilege to create resource pools. |
| PRIV_CREATE_RESOURCE_UNIT | varchar(3) | NO | The privilege to create resource units. This field defines the specifications of hardware resources. Hardware resources are allocated to tenants based on resource units. |
| MAX_CONNECTIONS | bigint(20) | NO | The maximum number of connections. |
| MAX_USER_CONNECTIONS | bigint(20) | NO | The maximum number of tenant connections. |
| PRIV_REPL_SLAVE | varchar(3) | NO | The privilege to manage secondary servers. The tenant can determine the locations of the secondary and primary servers for replication. |
| PRIV_REPL_CLIENT | varchar(3) | NO | The privilege to manage primary servers. The tenant can read binary log files that are used to maintain the replicated database environment. This user is located in the primary system to facilitate the communication between the host and the client. |