Feature
This view displays the database privileges of the current tenant.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| USER_ID | bigint(20) | NO | The ID of the user. |
| USERNAME | varchar(128) | NO | The username. |
| DATABASE_NAME | varchar(128) | NO | The name of the database. |
| GMT_CREATE | timestamp(6) | NO | The time when the user was created. |
| GMT_MODIFIED | timestamp(6) | NO | The time when the user was modified. |
| 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. |