CodeListing 5: Adding INSERT/UPDATE/DELETE policies in table CUSTOMERS

begin
dbms_rls.add_policy (
    object_schema    => 'BANK',
    object_name      => 'CUSTOMERS',
    policy_name      => 'CUST_IUD_POLICY',
    function_schema  => 'SECMAN',
    policy_function  => 'GET_IUD_CUST_ID',
    statement_types  => 'INSERT, UPDATE, DELETE',
    update_check     => TRUE
 );
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