I have been playing around with Oracle Flashback Query in order to move to a more out the box set of functions for data auditing over our custom table and trigger approach.
All is working really well so far but I have a question about VPD protected tables.
If within my schema, I have a VPD protected table called PERSON, when I connect as SQL*Plus and issue:
SELECT *
FROM person;
Then I get 0 rows returned (as expected). Data is only returned once my application contexts are set up (an APEX Application does this).
If however I run via SQL*Plus:
SELECT *
FROM person AS OF TIMESTAMP SYSDATE-3;
The I get to see all data.
Is there any way of configuring Oracle Flashback Query to respect, in-play table VPD Policies?
Thanks for any help.
Duncs