Oracle PL/SQL Tutorial/System Tables Data Dictionary/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>