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;