|
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;
|