add_rpol_relcols_opts.sql

OReilly Oracle PL SQL Programming第4版源代码

begin
   dbms_rls.drop_policy (
      object_schema         => 'HR',
      object_name           => 'EMP',
      policy_name           => 'EMP_POLICY'
   );
   dbms_rls.add_policy (
      object_schema         => 'HR',
      object_name           => 'EMP',
      policy_name           => 'EMP_POLICY',
      function_schema       => 'RLSOWNER',
      policy_function       => 'AUTHORIZED_EMPS',
      statement_types       => 'SELECT',
      update_check          => true,
      sec_relevant_cols     => 'SAL, COMM',
      sec_relevant_cols_opt => dbms_rls.all_rows
   );
end;