Capturing the Results of queries in an audit table.
Customer has expressed a desire to capture not just the query executed by the users, but to actually capture the results set of every query executed against a specific table.
The question they want to be able to be answered is "X was released to the press... Who as run a query that returned the record that contained X?" In this day and age of Wikileaks and other data compromises, I can see this becoming an issue and question several organizations might need to address (storage requirements aside!!)
I suppose that we could do something like flashback query (for each query in the audit trail that hits the table) but then we have to keep undo data for years? That doesn't seem workable.
A simple query against an audit table that can be queried to show "these users ran queries that returned X on the folllowing days" seems the best course but the only way I can think of to do this would be to have a trigger to capture the results.
I'm hoping someone can point me to a easier way to use an oracle built in to accomplish this. (BTW, we are using 11gR2 DB.)
Thanks for any suggestions!