Purpose
The ROLE_TAB_PRIVS view displays table privileges granted to roles. Information is provided only about roles to which the user has access.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | 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. |