11 12 13

11-
ROLE_TAB_PRIVS
SESSION_PRIVS
SESSION_ROLES
TABLE_PRIVILEGES

12-

SQL> describe TABLE_PRIVILEGES;
 Name       Null?     Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 GRANTEE       NOT NULL VARCHAR2(30)
 OWNER       NOT NULL VARCHAR2(30)
 TABLE_NAME       NOT NULL VARCHAR2(30)
 GRANTOR       NOT NULL VARCHAR2(30)
 SELECT_PRIV                                                                                                 VARCHAR2(1)
 INSERT_PRIV                                                                                                 VARCHAR2(1)
 DELETE_PRIV                                                                                                 VARCHAR2(1)
 UPDATE_PRIV                                                                                                 VARCHAR2(1)
 REFERENCES_PRIV                                                                                             VARCHAR2(1)
 ALTER_PRIV                                                                                                  VARCHAR2(1)
 INDEX_PRIV                                                                                                  VARCHAR2(1)
 CREATED                                                                                                     VARCHAR2

//SELECT DISTINCT GRANTEE FROM TABLE_PRIVILEGES;
SELECT GRANTOR, TABLE_NAME, SELECT_PRIV, INSERT_PRIV, DELETE_PRIV, REFERENCES_PRIV, ALTER_PRIV, INDEX_PRIV  FROM TABLE_PRIVILEGES WHERE GRANTEE='IL_U1';

13-
SELECT GRANTEE, TABLE_NAME, SELECT_PRIV, INSERT_PRIV, DELETE_PRIV, REFERENCES_PRIV, ALTER_PRIV, INDEX_PRIV  FROM TABLE_PRIVILEGES WHERE GRANTOR='IL_U1';