DBMS_FGA.ADD_POLICY : DBMS_FGA « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. DBMS_FGA

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>

   
  

Related examples in the same category