Query all_tab_privs
SQL> SQL> SELECT grantee, privilege, grantable 2 FROM all_tab_privs 3 WHERE table_schema = 'GENNICK' 4 AND table_name = 'emp'; no rows selected SQL> SQL>