Purpose
The information_schema.COLUMN_PRIVILEGES view displays the information about column privileges.
Note
This view was introduced in OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| GRANTEE | varchar(292) | NO | The username of the user to which the privileges are granted. |
| TABLE_CATALOG | varchar(512) | NO | The name of the directory where the table that contains the column is located. The value of this column is always def. |
| TABLE_SCHEMA | varchar(64) | NO | The database where the table that contains the column is located. |
| TABLE_NAME | varchar(64) | NO | The name of the table that contains the column. |
| COLUMN_NAME | varchar(64) | NO | The name of the column. |
| PRIVILEGE_TYPE | varchar(64) | NO | The granted privileges. The value can be any privileges at the column level. |
| IS_GRANTABLE | varchar(3) | NO | Indicates whether the user can grant the privileges. Valid values:YESNO |