My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.