Feature
ROLE_TAB_PRIVS describes table privileges granted to roles. This view displays only information about roles accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| ROLE | VARCHAR2(128) | NO | The name of the role. |
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the object. |
| COLUMN_NAME | VARCHAR2(128) | NO | The name of the column (if any). |
| PRIVILEGE | VARCHAR2(40) | NO | The object privilege granted to the role. |
| GRANTABLE | VARCHAR2(3) | NO | Indicates whether the role was granted with the ADMIN option. |