云数据库 GaussDB-ALTER MASKING POLICY:语法格式

时间:2023-11-01 16:22:24

语法格式

  • 修改策略描述:
    1
    ALTER MASKING POLICY policy_name COMMENTS policy_comments;
  • 修改脱敏方式:
    123
    ALTER MASKING POLICY policy_name [ADD | REMOVE | MODIFY] masking_actions[, ...]*;其中masking_action:    masking_function ON LABEL(label_name[, ...]*)
  • 修改脱敏策略生效场景:
    1
    ALTER MASKING POLICY policy_name MODIFY(FILTER ON FILTER_TYPE(filter_value[, ...]*)[, ...]*);
  • 移除脱敏策略生效场景,使策略对所用场景生效:
    1
    ALTER MASKING POLICY policy_name DROP FILTER;
  • 修改脱敏策略开启/关闭:
    1
    ALTER MASKING POLICY policy_name [ENABLE | DISABLE];
support.huaweicloud.com/devg-opengauss/opengauss_devg_0499.html