[GitHub] [shardingsphere] RaigorJiang commented on issue #22759: [New Feature] Implement new data masking feature for users with security needs

[GitBox <gi...@apache.org>]

RaigorJiang commented on issue #22759:
URL: https://github.com/apache/shardingsphere/issues/22759#issuecomment-1366500639

   Hi @strongduanmu ,
   I want to add DistSQL for mask rule:
   ```sql
   # CREATE
   CREATE MASK RULE (IF NOT EXISTS)? t_mask (
   COLUMNS(
   (NAME=telephone,TYPE(NAME='INDEX_BASED_REPLACE',PROPERTIES("start-index"=3,"stop-index"=8,"replace-char"="*"))),
   (NAME=address,TYPE(NAME='MD5'))
   ));
   
   # ALTER
   ALTER MASK RULE t_mask (
   COLUMNS(
   (NAME=telephone,TYPE(NAME='INDEX_BASED_REPLACE',PROPERTIES("start-index"=3,"stop-index"=8,"replace-char"="*"))),
   (NAME=address,TYPE(NAME='MD5'))
   ));
   
   # DROP
   DROP MASK RULE (IF EXISTS)? t_mask;
   
   # SHOW
   SHOW MASK (RULE ruleName | RULES) (FROM databaseName)?
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org