Note
This view is available starting with V2.2.77.
Purpose
This view describes the column privileges granted to the current user as the owner, grantor, or grantee.
Note
Oracle-compatible mode of OceanBase Database does not support column privileges.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The name of the user to whom the privilege is granted. |
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| TABLE_NAME | VARCHAR2(256) | NO | The name of the object. |
| COLUMN_NAME | VARCHAR2(128) | NO | The name of the column. |
| GRANTOR | VARCHAR2(128) | NO | The name of the user who grants the privilege. |
| PRIVILEGE | VARCHAR2(40) | NO | The privilege granted on the column. |
| GRANTABLE | VARCHAR2(3) | NO | Whether the privilege can be granted by using the GRANT statement. |