ALTER ENCRYPT RULE

说明

ALTER ENCRYPT RULE 语法用于修改加密规则。

语法

语法 铁路图

  1. AlterEncryptRule ::=
  2.   'ALTER' 'ENCRYPT' 'RULE' encryptDefinition (',' encryptDefinition)*
  4. encryptDefinition ::=
  5.   ruleName '(' 'COLUMNS' '(' columnDefinition (',' columnDefinition)*  ')' ')'
  7. columnDefinition ::=
  8.   '(' 'NAME' '=' columnName ',' 'CIPHER' '=' cipherColumnName (',' 'ASSISTED_QUERY' '=' assistedQueryColumnName)? (',' 'LIKE_QUERY' '=' likeQueryColumnName)? ',' encryptAlgorithmDefinition (',' assistedQueryAlgorithmDefinition)? (',' likeQueryAlgorithmDefinition)? ')' 
  10. encryptAlgorithmDefinition ::=
  11.   'ENCRYPT_ALGORITHM' '(' 'TYPE' '(' 'NAME' '=' encryptAlgorithmType (',' propertiesDefinition)? ')'
  13. assistedQueryAlgorithmDefinition ::=
  14.   'ASSISTED_QUERY_ALGORITHM' '(' 'TYPE' '(' 'NAME' '=' encryptAlgorithmType (',' propertiesDefinition)? ')'
  16. likeQueryAlgorithmDefinition ::=
  17.   'LIKE_QUERY_ALGORITHM' '(' 'TYPE' '(' 'NAME' '=' encryptAlgorithmType (',' propertiesDefinition)? ')'
  19. propertiesDefinition ::=
  20.   'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'
  22. tableName ::=
  23.   identifier
  25. columnName ::=
  26.   identifier
  28. cipherColumnName ::=
  29.   identifier
  31. assistedQueryColumnName ::=
  32.   identifier
  34. likeQueryColumnName ::=
  35.   identifier
  37. encryptAlgorithmType ::=
  38.   string
  40. key ::=
  41.   string
  43. value ::=
  44.   literal

补充说明

  • CIPHER 指定密文数据列，ASSISTED_QUERY 指定辅助查询列，LIKE_QUERY 指定模糊查询列；
  • encryptAlgorithmType 指定加密算法类型，请参考 加密算法；
  • 重复的 ruleName 将无法被创建。

示例

  • 修改加密规则
  1. ALTER ENCRYPT RULE t_encrypt (
  2. COLUMNS(
  3. (NAME=user_id,CIPHER=user_cipher,ASSISTED_QUERY=assisted_query_user,LIKE_QUERY=like_query_user,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5')),LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE'))),
  4. (NAME=order_id,CIPHER=order_cipher,ASSISTED_QUERY=assisted_query_order,LIKE_QUERY=like_query_order,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5')),LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE')))
  5. ));

保留字

ALTER、ENCRYPT、RULE、COLUMNS、NAME、CIPHER、ASSISTED_QUERY、LIKE_QUERY、ENCRYPT_ALGORITHM、ASSISTED_QUERY_ALGORITHM、LIKE_QUERY_ALGORITHM、TYPE、TRUE、FALSE

相关链接