Logo
ALTER MASK RULE

描述 #

ALTER MASK RULE 语法用于修改数据脱敏规则.

语法定义 #

CreateEncryptRule ::=
  'ALTER' 'MASK' 'RULE' maskRuleDefinition (',' maskRuleDefinition)*

maskRuleDefinition ::=
ruleName '(' 'COLUMNS' '(' columnDefinition (',' columnDefinition)* ')' ')'


columnDefinition ::=
'(' 'NAME' '=' columnName ',' maskAlgorithmDefinition ')'


maskAlgorithmDefinition ::=
'TYPE' '(' 'NAME' '=' maskAlgorithmType (',' propertiesDefinition)? ')'


propertiesDefinition ::=
'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'


ruleName ::=
identifier


columnName ::=
identifier


maskAlgorithmType ::=
literal


key ::=
string


value ::=
literal

补充说明 #

示例 #

修改数据脱敏规则 #

ALTER MASK RULE t_mask (
COLUMNS(
(NAME=phone_number,TYPE(NAME='MASK_FROM_X_TO_Y', PROPERTIES("from-x"=1, "to-y"=2, "replace-char"="*"))),
(NAME=address,TYPE(NAME='MD5'))
));

保留字 #

ALTER、MASK、RULE、COLUMNS、NAME、TYPE

相关链接 #