1. Transaction Manager for Microservices Developer Guide
  2. Develop Applications with XA
  3. Required User Privileges

7.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.

Parent topic: Develop Applications with XA