Mark Harrison Mark Harrison - 1 year ago 64
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 Source
grant execute on dbms_flashback to public;
grant flashback any table to public;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download