Skip to Main Content

Oracle Database Discussions

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!

How to check if VPD policies are enabled/disabled

575432Sep 24 2007 — edited Sep 26 2007
Hi all,

I have enabled all the policies in my db.

To check if VPD policies are enabled I had issued the below query.

SQL> select OBJECT_NAME, POLICY_NAME, ENABLE from user_policies
2 /

no rows selected

The above query retrurns 0 rows.

What could be the problem and how can we achieve this.

Thanks
Sudha
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2007
Added on Sep 24 2007
3 comments
4,114 views