Oracle PL/SQL/System Tables Views/all col privs
Query all_col_privs
<source lang="sql">
SQL> SQL> COLUMN grantee FORMAT A12 SQL> COLUMN privilege FORMAT A12 SQL> COLUMN column_name FORMAT A15 SQL> SQL> SELECT grantee, privilege, column_name, grantable
2 FROM all_col_privs 3 WHERE table_schema = "GENNICK" 4 AND table_name = "emp";
no rows selected SQL> SQL>
</source>