CodeListing 6: Adding Select policy on table ACCOUNTS

begin
   dbms_rls.add_policy (
      object_schema    => 'BANK',
      object_name      => 'ACCOUNTS',
      policy_name      => 'ACCOUNT_ACCESS_POLICY',
      function_schema  => 'BANK',
      policy_function  => 'GET_SEL_CUST_ID',
      statement_types  => 'SELECT'
   );
end;

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy