Mark Harrison Mark Harrison - 7 months ago 12
SQL Question

Oracle: how to enable flashback "as of" queries for all developers?

How do I enable flashback queries for all of my developers on my Oracle instance?

Flashback queries are executed as of a particular time so that

select * from mytable as of timestamp(sysdate-1);


will show the contents of the table as of 24 hours ago.

Answer
grant execute on dbms_flashback to public;
grant flashback any table to public;