This is an automated email from the ASF dual-hosted git repository.
kassiez pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 01ff24e00c6 [docs](sql-statement) Update ALTER SQL_BLOCK_RULE (#2031)
01ff24e00c6 is described below
commit 01ff24e00c6c7538cb4db89ed49ec7dfc19cb71d
Author: KassieZ <[email protected]>
AuthorDate: Wed Feb 12 16:51:28 2025 +0800
[docs](sql-statement) Update ALTER SQL_BLOCK_RULE (#2031)
## Versions
- [ ] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [ ] Chinese
- [ ] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../data-governance/ALTER-SQL_BLOCK_RULE.md | 49 ++++++++++++----------
.../data-governance/ALTER-SQL_BLOCK_RULE.md | 47 +++++++++++----------
.../data-governance/ALTER-SQL_BLOCK_RULE.md | 47 +++++++++++----------
.../data-governance/ALTER-SQL_BLOCK_RULE.md | 47 +++++++++++----------
.../data-governance/ALTER-SQL_BLOCK_RULE.md | 49 ++++++++++++----------
.../data-governance/ALTER-SQL_BLOCK_RULE.md | 49 ++++++++++++----------
6 files changed, 157 insertions(+), 131 deletions(-)
diff --git
a/docs/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
b/docs/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
index 32cccdd3a97..17271ab1728 100644
--- a/docs/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
+++ b/docs/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
@@ -25,41 +25,46 @@ under the License.
-->
-
## Description
-Modify SQL blocking rules to allow modification of each item such as
sql/sqlHash/partition_num/tablet_num/cardinality/global/enable.
+This statement is used to modify an SQL block rule.
+
+## Syntax
-grammar:
```sql
-ALTER SQL_BLOCK_RULE rule_name
-[PROPERTIES ("key"="value", ...)];
+ALTER SQL_BLOCK_RULE <rule_name>
+PROPERTIES (
+ -- property
+ <property>
+ -- Additional properties
+ [ , ... ]
+ )
```
-illustrate:
+## Required Parameters
-- sql and sqlHash cannot be set at the same time. This means that if a rule
sets sql or sqlHash, the other attribute cannot be modified;
-- sql/sqlHash and partition_num/tablet_num/cardinality cannot be set at the
same time. For example, if a rule sets partition_num, then sql or sqlHash
cannot be modified;
+**1. `<rule_name>`**
-## Example
+> The name of the rule.
-1. Modify according to SQL properties
+**2. `<property>`**
-```sql
-ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
-```
+See the introduction of [CREATE
SQL_BLOCK_RULE](../data-governance/CREATE-SQL_BLOCK_RULE.md) for details.
-2. If a rule sets partition_num, then sql or sqlHash cannot be modified
+## Access Control Requirements
-```sql
-ALTER SQL_BLOCK_RULE test_rule2 PROPERTIES("partition_num" =
"10","tablet_num"="300","enable"="true")
-```
+The user executing this SQL command must have at least the following
permissions:
-## Keywords
+| Privilege | Object | Notes |
+| ------------ | ------ | ----------- |
+| ADMIN_PRIV | Global | |
+
+## Example
+
+1. Modify the SQL and enable the rule
-```text
-ALTER,SQL_BLOCK_RULE
-```
-## Best Practice
+ ```sql
+ ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
index 25bf7fc2926..edf78bfcbcd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
@@ -25,41 +25,44 @@ under the License.
-->
-
## 描述
-修改 SQL 阻止规则，允许对 sql/sqlHash/partition_num/tablet_num/cardinality/global/enable
等每一项进行修改。
+该语句用于修改 SQL 阻止规则
-语法：
+## 语法
```sql
-ALTER SQL_BLOCK_RULE rule_name
-[PROPERTIES ("key"="value", ...)];
+ALTER SQL_BLOCK_RULE <rule_name>
+PROPERTIES (
+ -- property
+ <property>
+ -- Additional properties
+ [ , ... ]
+ )
```
-说明：
+## 必选参数
-- sql 和 sqlHash 不能同时被设置。这意味着，如果一个 rule 设置了 sql 或者 sqlHash，则另一个属性将无法被修改；
-- sql/sqlHash 和 partition_num/tablet_num/cardinality 不能同时被设置。举个例子，如果一个 rule
设置了 partition_num，那么 sql 或者 sqlHash 将无法被修改；
+**1. `<rule_name>`**
-## 示例
+> 规则的名字
-1. 根据 SQL 属性进行修改
+**2. `<property>`**
-```sql
-ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
-```
+具体见[CREATE SQL_BLOCK_RULE](../data-governance/CREATE-SQL_BLOCK_RULE.md) 的介绍
-2. 如果一个 rule 设置了 partition_num，那么 sql 或者 sqlHash 将无法被修改
+## 权限控制
-```sql
-ALTER SQL_BLOCK_RULE test_rule2 PROPERTIES("partition_num" =
"10","tablet_num"="300","enable"="true")
-```
+执行此 SQL 命令的用户必须至少具有以下权限：
-## 关键词
+| 权限 | 对象 | 说明 |
+| :---------------- | :------------- | :------------ |
+| ADMIN_PRIV | 全局 | |
-```text
-ALTER,SQL_BLOCK_RULE
-```
+## 示例
-### 最佳实践
+1. 修改 sql 并开启规则
+
+ ```sql
+ ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
index 4484d27569a..f18624bfa57 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
@@ -29,39 +29,42 @@ under the License.
## 描述
+该语句用于修改 SQL 阻止规则
-修改 SQL 阻止规则，允许对 sql/sqlHash/partition_num/tablet_num/cardinality/global/enable
等每一项进行修改。
-
-语法：
+## 语法
```sql
-ALTER SQL_BLOCK_RULE rule_name
-[PROPERTIES ("key"="value", ...)];
+ALTER SQL_BLOCK_RULE <rule_name>
+PROPERTIES (
+ -- property
+ <property>
+ -- Additional properties
+ [ , ... ]
+ )
```
-说明：
-- sql 和 sqlHash 不能同时被设置。这意味着，如果一个 rule 设置了 sql 或者 sqlHash，则另一个属性将无法被修改；
-- sql/sqlHash 和 partition_num/tablet_num/cardinality 不能同时被设置。举个例子，如果一个 rule
设置了 partition_num，那么 sql 或者 sqlHash 将无法被修改；
+## 必选参数
+**1. `<rule_name>`**
-## 示例
+> 规则的名字
-1. 根据 SQL 属性进行修改
+**2. `<property>`**
- ```sql
- ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
- ```
+具体见[CREATE SQL_BLOCK_RULE](../data-governance/CREATE-SQL_BLOCK_RULE.md) 的介绍
-2. 如果一个 rule 设置了 partition_num，那么 sql 或者 sqlHash 将无法被修改
+## 权限控制
- ```sql
- ALTER SQL_BLOCK_RULE test_rule2 PROPERTIES("partition_num" =
"10","tablet_num"="300","enable"="true")
- ```
+执行此 SQL 命令的用户必须至少具有以下权限：
-## 关键词
+| 权限 | 对象 | 说明 |
+| :---------------- | :------------- | :------------ |
+| ADMIN_PRIV | 全局 | |
-```text
-ALTER,SQL_BLOCK_RULE
-```
+## 示例
-## 最佳实践
+1. 修改 sql 并开启规则
+
+ ```sql
+ ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
index 25bf7fc2926..edf78bfcbcd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
@@ -25,41 +25,44 @@ under the License.
-->
-
## 描述
-修改 SQL 阻止规则，允许对 sql/sqlHash/partition_num/tablet_num/cardinality/global/enable
等每一项进行修改。
+该语句用于修改 SQL 阻止规则
-语法：
+## 语法
```sql
-ALTER SQL_BLOCK_RULE rule_name
-[PROPERTIES ("key"="value", ...)];
+ALTER SQL_BLOCK_RULE <rule_name>
+PROPERTIES (
+ -- property
+ <property>
+ -- Additional properties
+ [ , ... ]
+ )
```
-说明：
+## 必选参数
-- sql 和 sqlHash 不能同时被设置。这意味着，如果一个 rule 设置了 sql 或者 sqlHash，则另一个属性将无法被修改；
-- sql/sqlHash 和 partition_num/tablet_num/cardinality 不能同时被设置。举个例子，如果一个 rule
设置了 partition_num，那么 sql 或者 sqlHash 将无法被修改；
+**1. `<rule_name>`**
-## 示例
+> 规则的名字
-1. 根据 SQL 属性进行修改
+**2. `<property>`**
-```sql
-ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
-```
+具体见[CREATE SQL_BLOCK_RULE](../data-governance/CREATE-SQL_BLOCK_RULE.md) 的介绍
-2. 如果一个 rule 设置了 partition_num，那么 sql 或者 sqlHash 将无法被修改
+## 权限控制
-```sql
-ALTER SQL_BLOCK_RULE test_rule2 PROPERTIES("partition_num" =
"10","tablet_num"="300","enable"="true")
-```
+执行此 SQL 命令的用户必须至少具有以下权限：
-## 关键词
+| 权限 | 对象 | 说明 |
+| :---------------- | :------------- | :------------ |
+| ADMIN_PRIV | 全局 | |
-```text
-ALTER,SQL_BLOCK_RULE
-```
+## 示例
-### 最佳实践
+1. 修改 sql 并开启规则
+
+ ```sql
+ ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
+ ```
\ No newline at end of file
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
index 6d5fba5684a..d42fe997e19 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
@@ -26,41 +26,46 @@ under the License.
-
## Description
-Modify SQL blocking rules to allow modification of each item such as
sql/sqlHash/partition_num/tablet_num/cardinality/global/enable.
+This statement is used to modify an SQL block rule.
+
+## Syntax
-grammar:
```sql
-ALTER SQL_BLOCK_RULE rule_name
-[PROPERTIES ("key"="value", ...)];
+ALTER SQL_BLOCK_RULE <rule_name>
+PROPERTIES (
+ -- property
+ <property>
+ -- Additional properties
+ [ , ... ]
+ )
```
-illustrate:
+## Required Parameters
-- sql and sqlHash cannot be set at the same time. This means that if a rule
sets sql or sqlHash, the other attribute cannot be modified;
-- sql/sqlHash and partition_num/tablet_num/cardinality cannot be set at the
same time. For example, if a rule sets partition_num, then sql or sqlHash
cannot be modified;
+**1. `<rule_name>`**
-## Examples
+> The name of the rule.
-1. Modify according to SQL properties
+**2. `<property>`**
-```sql
-ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
-```
+See the introduction of [CREATE
SQL_BLOCK_RULE](../data-governance/CREATE-SQL_BLOCK_RULE.md) for details.
-2. If a rule sets partition_num, then sql or sqlHash cannot be modified
+## Access Control Requirements
-```sql
-ALTER SQL_BLOCK_RULE test_rule2 PROPERTIES("partition_num" =
"10","tablet_num"="300","enable"="true")
-```
+The user executing this SQL command must have at least the following
permissions:
-## Keywords
+| Privilege | Object | Notes |
+| ------------ | ------ | ----------- |
+| ADMIN_PRIV | Global | |
+
+## Example
+
+1. Modify the SQL and enable the rule
-```text
-ALTER,SQL_BLOCK_RULE
-```
-## Best Practice
+ ```sql
+ ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
+ ```
\ No newline at end of file
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
b/versioned_docs/version-3.0/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
index 32cccdd3a97..9c29f01ac46 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE.md
@@ -26,40 +26,47 @@ under the License.
+
## Description
-Modify SQL blocking rules to allow modification of each item such as
sql/sqlHash/partition_num/tablet_num/cardinality/global/enable.
+This statement is used to modify an SQL block rule.
+
+## Syntax
-grammar:
```sql
-ALTER SQL_BLOCK_RULE rule_name
-[PROPERTIES ("key"="value", ...)];
+ALTER SQL_BLOCK_RULE <rule_name>
+PROPERTIES (
+ -- property
+ <property>
+ -- Additional properties
+ [ , ... ]
+ )
```
-illustrate:
+## Required Parameters
-- sql and sqlHash cannot be set at the same time. This means that if a rule
sets sql or sqlHash, the other attribute cannot be modified;
-- sql/sqlHash and partition_num/tablet_num/cardinality cannot be set at the
same time. For example, if a rule sets partition_num, then sql or sqlHash
cannot be modified;
+**1. `<rule_name>`**
-## Example
+> The name of the rule.
-1. Modify according to SQL properties
+**2. `<property>`**
-```sql
-ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
-```
+See the introduction of [CREATE
SQL_BLOCK_RULE](../data-governance/CREATE-SQL_BLOCK_RULE.md) for details.
-2. If a rule sets partition_num, then sql or sqlHash cannot be modified
+## Access Control Requirements
-```sql
-ALTER SQL_BLOCK_RULE test_rule2 PROPERTIES("partition_num" =
"10","tablet_num"="300","enable"="true")
-```
+The user executing this SQL command must have at least the following
permissions:
-## Keywords
+| Privilege | Object | Notes |
+| ------------ | ------ | ----------- |
+| ADMIN_PRIV | Global | |
+
+## Example
+
+1. Modify the SQL and enable the rule
-```text
-ALTER,SQL_BLOCK_RULE
-```
-## Best Practice
+ ```sql
+ ALTER SQL_BLOCK_RULE test_rule PROPERTIES("sql"="select \\* from
test_table","enable"="true")
+ ```
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
