Oracle Tips by Burleson

Chapter 13 Oracle 10g Enhancements

    static_policy    => FALSE
);
end;
/

The new parameter policy_type indicates the type of policy. The above code can be written as:

begin
dbms_rls.add_policy (
    object_schema    => 'CLAIM_SCHEMA',
    object_name      => 'CLAIMS',
    policy_name      => 'CLAIM_VIEW_POLICY',
    function_schema  => 'CLAIM_SCHEMA',
    policy_function  => 'GET_AUTH_PROVIDERS',
    statement_types  =>
        'INSERT, UPDATE, DELETE, SELECT',
    update_check     => TRUE,
    enable           => TRUE,
    policy_type      => dbms_rls.dynamic
);
end;
/

Here, it is assumed that the policy is dynamic, which is the default type. Also note that the parameter static_policy is no longer present as a valid parameter.

The behavior of this policy will be exactly the same as the Oracle 9i policy type; where the policy function will be executed for each call to the table.