Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 847
Mark Harrison Avatar asked Nov 08 '25 07:11

Mark Harrison


1 Answers

grant execute on dbms_flashback to public;
grant flashback any table to public;
like image 156
Mark Harrison Avatar answered Nov 09 '25 20:11

Mark Harrison



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!