Query all_col_privs
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>
Related examples in the same category