SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Policy is not available

SudhakarRNov 12 2013 — edited Nov 13 2013

Hi,

I'm new to VPD and trying to create VPD for our new deployment.

I created a policy on a table and dbms_rls.add_policy is executed successfully.

could you please help me and explain below questions?

* After successfully executed dbms_rls.add_policy package, its available in all_policies, but I couldnt find the entry in v$vpd_policy. because of this I'm not able to drop the policy or recreate the policy.
* do I need to recreate policy whenever I did modification in related function?

* is there any way to debug dbms_rls errors? I got error ''ORA-28113: policy predicate has error' when I access related table?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2013

Added on Nov 12 2013

3 comments

261 views