| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
ROLE_TAB_PRIVS describes table privileges granted to roles. Information is provided only about roles to which the user has access.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
ROLE | 
VARCHAR2(30) | 
NOT NULL | 
Name of the role | 
OWNER | 
VARCHAR2(30) | 
NOT NULL | 
Owner of the object | 
TABLE_NAME | 
VARCHAR2(30) | 
NOT NULL | 
Name of the object | 
COLUMN_NAME | 
VARCHAR2(30) | 
Name of the column, if applicable | |
PRIVILEGE | 
VARCHAR2(40) | 
NOT NULL | 
Object privilege granted to the role | 
GRANTABLE | 
VARCHAR2(3) | 
YES if the role was granted with ADMIN OPTION; otherwise NO |