Feature
This view provides all information about the current tenant.
Fields
| Field | 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 for 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 drop database or table records. |
| PRIV_DROP | varchar(3) | NO | The privilege to drop databases or tables. |
| PRIV_GRANT_OPTION | varchar(3) | NO | The privilege granted on 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 check 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 privilege. |
| 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 SSL type for standard encryption. |
| SSL_CIPHER | varchar(1024) | NO | The SSL cypher for standard encryption. |
| X509_ISSUER | varchar(1024) | NO | The name of the X.509 issuer. |
| X509_SUBJECT | varchar(1024) | NO | The subject name of the X.509 certificate. |
| TYPE | varchar(4) | NO | The type. |
| PROFILE_ID | bigint(20) | NO | The ID of the document. |
| 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 change 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 unit configurations, which describe the specifications of hardware resources allocated to tenants. |
| 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. A tenant can determine the location of secondary and primary servers for replication. |
| PRIV_REPL_CLIENT | varchar(3) | NO | The privilege to manage primary servers. A tenant can read the binary log files to maintain the database replication environment. The user is in the primary system, which facilitates communication between the host and clients. |