CodeListing 4: Adding SELECT policy on table CUSTOMERS

begin
dbms_rls.add_policy (
    object_schema    => 'BANK',
    object_name      => 'CUSTOMERS',
    policy_name      => 'CUST_SEL_POLICY',
    function_schema  => 'SECMAN',
    policy_function  => 'GET_SEL_CUST_ID',
    statement_types  => 'SELECT',
    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