Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

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>