I am using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi.
Documentation says"
◦For Flashback Query and Flashback Version Query, grant _FLASHBACK_ and SELECT privileges on specific objects to be accessed during queries or grant the FLASHBACK ANY TABLE privilege to allow queries on all tables. "
However, I do not see flashback privilege, but I am still able to use flashback query if the table is in same schema.
All the following select yeields -
no rows found.
select * from user_tab_privs where privilege like '%FLASHBACK%'
select * from USER_SYS_PRIVS where privilege like '%FLASHBACK%'
select * from role_tab_privs where privilege like '%FLASHBACK%'
select * from role_sys_privs where privilege like '%FLASHBACK%'
What privilege do we need to use flashback query? +Why I am able to use flashback query ( select * from <tablename> as of SCN ...) without the privilege?
+Note: Flashback_on in V$database table is NO
Edited by: spur230 on Mar 11, 2011 1:39 PM