add_fpol_10g_1.sql

begin
   dbms_fga.add_policy (
      object_schema   => 'HR',
      object_name     => 'EMP',
      policy_name     => 'EMP_DML',
      audit_column    => 'SALARY, COMM',
      audit_condition => 'SALARY >= 150000 OR EMPID = 100',
      statement_types => 'SELECT, INSERT, DELETE, UPDATE'
   );
end;
/



/*======================================================================
| Supplement to the fifth edition of Oracle PL/SQL Programming by Steven
| Feuerstein with Bill Pribyl, Copyright (c) 1997-2009 O'Reilly Media, Inc. 
| To submit corrections or find more code samples visit
| http://oreilly.com/catalog/9780596514464/
*/