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;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With