Oracle PL/SQL/System Packages/DBMS FGA

Материал из SQL эксперт
Перейти к: навигация, поиск

DBMS_FGA.ADD_POLICY

 
SQL>
SQL> begin
  2    DBMS_FGA.ADD_POLICY(object_schema   => "Smart",
  3                        object_name     => "EMP",
  4                        policy_name     => "EMP_TRIG_AUD",
  5                        audit_condition => "1=1",
  6                        audit_column    => NULL,
  7                        handler_schema  => NULL,
  8                        handler_module  => NULL,
  9                        enable          => TRUE,
 10                        statement_types => "SELECT,INSERT,UPDATE,DELETE");
 11   end;
 12   /

SQL>
SQL>