add_policy_2.sql

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

begin
   dbms_rls.add_policy (
      object_name      => 'EMP',
      policy_name      => 'EMP_POLICY',
      function_schema  => 'HR',
      policy_function  => 'AUTHORIZED_EMPS',
      statement_types  => 'INSERT, UPDATE, DELETE, SELECT',
      update_check     => true
   );
end;
/