Purpose
The oceanbase.CDB_OB_USERS view displays all information about the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| 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 information about the tenant. |
| 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 view 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 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 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 column 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. |
