Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking
  3. Rules
  4. Connection Rules
  5. Security Rules
  6. Security Rule Set Simulator
  7. Masking Functions
  8. Stored Procedure Result Set Masking
  9. Integration with Informatica Products
  10. Appendix A: XML Functions Reference
  11. Appendix B: Glossary

User Guide

User Guide

Masking Rule

Masking Rule

In the masking rule folder, create the masking rule.
To create the masking rule, assign the text matcher to identify SELECT lists that contain the Social Security column. If the SELECT list matches the security rule criteria, the Rule Engine applies the mask action to the SELECT list. The mask action hides all the digits of the Social Security number. Enable the keep matcher result option to store the matched result. Then, apply the Stop if Applied processing action. If the Rule Engine applies the action, the Rule Engine does not continue to process the SQL statement through the rule tree and forwards the rewritten request to the database. Otherwise, the Rule Engine processes the SQL statement through the next rule.