Grant specific privileges for a Flashback Query

This is an OCM EXAM part. GRANT FLASHBACK ON SCOTT.BONUS_DROP TO SCOTT grant FLASHBACK ANY TABLE to scott -- ------------------------------------------------------------- http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_flashback.htm Grant flashback privileges to users, roles, or applications that need to use flashback features as follows: For the DBMS_FLASHBACK package, grant the EXECUTE privilege on DBMS_FLASHBACK to provide access to the features in this package. 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. For Flashback Transaction Query, grant the SELECT ANY TRANSACTION privilege. For Execution of undo SQL code, grant SELECT, UPDATE, DELETE, and INSERT privileges for specific tables, as appropriate, to permit execution of undo SQL code retrieved by a Flashback Transaction Query.