What Privileges Are Needed To Do A Flashback Transaction Backout ? (Doc ID 794595.1)

Last updated on MARCH 29, 2009

Applies to:

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

Symptoms

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

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


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


Cause

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