Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 |