What Privileges Are Needed To Do A Flashback Transaction Backout ?

(Doc ID 794595.1)

Last updated on OCTOBER 24, 2017

Applies to:

Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.


DBMS_FLASHBACK fails with ORA-1031 when executed by an user who is not granted the DBA role:

     trans_arr sys.xid_array;
     trans_arr := sys.xid_array('&1');
     dbms_flashback.transaction_backout (numtxns => 1,xids => trans_arr,options =>dbms_flashback.cascade,scnhint => 7643000);

ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_FLASHBACK", line 37
ORA-06512: at "SYS.DBMS_FLASHBACK", line 70
ORA-06512: at line 5


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms