6.7 Required User Privileges

You must have the following privileges to execute an XA transaction.

• GRANT SELECT ON SYS.DBA_PENDING_TRANSACTIONS TO user;
• GRANT SELECT ON SYS.DBA_2PC_PENDING TO user;
• GRANT EXECUTE ON SYS.DBMS_XA TO user;
• GRANT FORCE ANY TRANSACTION TO user;

Your system administrator or database administrator can grant these privileges.