Purpose
The information_schema.COLUMN_PRIVILEGES view provides information about column privileges.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| GRANTEE | varchar(292) | NO | The name of the user to which the access privilege is granted. |
| TABLE_CATALOG | varchar(512) | NO | The name of the catalog to which the table containing the column belongs. The value is always def. |
| TABLE_SCHEMA | varchar(64) | NO | The name of the database to which the table containing the column belongs. |
| TABLE_NAME | varchar(64) | NO | The name of the table containing the column. |
| COLUMN_NAME | varchar(64) | NO | The name of the column. |
| PRIVILEGE_TYPE | varchar(64) | NO | The privilege granted. The value be any privilege that can be granted at the column level. |
| IS_GRANTABLE | varchar(3) | NO | YES: The user has the grant option.NO: The user does not have the grant option. |