Overview
ROLE_TAB_PRIVS describes table privileges granted to roles. This view displays only information about roles accessible to the current user.
Field description
| Field name | 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. |
