You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/04/14 06:40:47 UTC

[shardingsphere] branch master updated: Add xa transaction required privilege document (#25165)

This is an automated email from the ASF dual-hosted git repository.

duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new 45e218dd5d3 Add xa transaction required privilege document (#25165)
45e218dd5d3 is described below

commit 45e218dd5d3d4e650b31c82107e1fa9e41865262
Author: ZhangCheng <fl...@outlook.com>
AuthorDate: Fri Apr 14 14:40:40 2023 +0800

    Add xa transaction required privilege document (#25165)
---
 docs/document/content/features/transaction/appendix.cn.md | 3 +++
 docs/document/content/features/transaction/appendix.en.md | 3 +++
 2 files changed, 6 insertions(+)

diff --git a/docs/document/content/features/transaction/appendix.cn.md b/docs/document/content/features/transaction/appendix.cn.md
index 1dd277950b3..886c0f13707 100644
--- a/docs/document/content/features/transaction/appendix.cn.md
+++ b/docs/document/content/features/transaction/appendix.cn.md
@@ -7,3 +7,6 @@ weight = 3
 
 - 事务中使用 DistSQL 里的 RAL、RDL 操作;
 - XA 事务中使用 DDL 语句。
+
+XA 事务所需的权限:
+在 MySQL8 中需要授予用户 `XA_RECOVER_ADMIN` 权限,否则 XA 事务管理器执行 `XA RECOVER` 语句时会报错。
diff --git a/docs/document/content/features/transaction/appendix.en.md b/docs/document/content/features/transaction/appendix.en.md
index 679e51432ed..c8579e8fb91 100644
--- a/docs/document/content/features/transaction/appendix.en.md
+++ b/docs/document/content/features/transaction/appendix.en.md
@@ -7,3 +7,6 @@ Unsupported SQL:
 
 - RAL and RDL operations of DistSQL are used in transactions.
 - DDL statements are used in XA transactions.
+
+Privileges required for XA transactions:
+In MySQL8, you need to grant the user `XA_RECOVER_ADMIN` privilege, otherwise the XA transaction manager will report an error when executing the `XA RECOVER` statement.