How to check if VPD policies are enabled/disabled
575432Sep 24 2007 — edited Sep 26 2007Hi 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