Oracle Virtal Private Database. How to refresh static policy
Hi
I wonder if this is correct behavior of VPD. We have renamed a column and have a table there we point out what column we should filter on. But it still trying to filter on the old column name. We tried the refresh procedure but it does not work, still using old static column.
I have post test case below to explain the problem. But i don´t understand if it is correct behavior or not.
Version we are running 11.2.0.3
We tried this.
Does not work
I wonder if this is correct behavior of VPD. We have renamed a column and have a table there we point out what column we should filter on. But it still trying to filter on the old column name. We tried the refresh procedure but it does not work, still using old static column.
I have post test case below to explain the problem. But i don´t understand if it is correct behavior or not.
Version we are running 11.2.0.3
We tried this.
Does not work
- dbms_rls.refresh_policy
- alter system flush shared_pool
- Restart database
- Recreate function
0