Purpose
ROLE_TAB_PRIVS displays table privileges granted to roles. Information is provided only about roles to which the user has access.
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. |