add_fpol_9i_1.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 11 行

begin
  dbms_fga.add_policy (
    object_schema => 'HR',
    object_name   => 'EMP',
    policy_name   => 'EMP_SEL',
    audit_column  => 'SAL, COMM',
    audit_condition => 'SAL >= 150000 OR EMPID = 100'
  );
end;