Mark Harrison Mark Harrison - 10 months ago 35
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.

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