Query all_tab_privs : all_tab_privs « System Tables Data Dictionary « Oracle PL/SQL Tutorial






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>








30.17.all_tab_privs
30.17.1.Query all_tab_privs