Flashback query privilege
430724Oct 27 2004 — edited Oct 27 2004What privileges are required to run table-level flashback queries using the "as of timestamp" clause in Oracle9i?
Tapani Lindgren
---
SQL> select sysdate from dual;
SYSDATE
---------
27-OCT-04
SQL> select sysdate from dual as of timestamp sysdate;
select sysdate from dual as of timestamp sysdate
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL>