CODEWITHSUNDEEP
sqloracle-database
Mark Harrison
Mark Harrison

Reputation: 304544

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.

Upvotes: 4

Views: 14006

Answers (3)

Yasin B
Yasin B

Reputation: 387

You can use flashback query for your own tables without needing any privileges. If you want other users to use flashback query on your tables you need to grant select and flashback privileges to those users.

If you want to see data as of 24 hours ago you need to have an adequately sized undo tablespace and properly set undo retention.

Also see this.

Upvotes: 1

Stephanie Page
Stephanie Page

Reputation: 3893

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_flashb.htm#BGBJEJGF

Upvotes: 0

Mark Harrison
Mark Harrison

Reputation: 304544

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

Upvotes: 7

Related Questions