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. XML Functions Reference
  11. Glossary

Creating Rules for Sensitive Columns

Creating Rules for Sensitive Columns

From the
Import Sensitive Columns
window, you can apply a masking action to any columns that are not protected by Dynamic Data Masking. You can also block all requests to a specific table.
  1. After you import the
    DataStoreDetails.csv
    file, review the list of protected and unprotected columns from the
    Import Sensitive Columns
    window.
  2. To protect any columns identified as unprotected, select either
    Mask
    or
    Block
    from the
    Action
    menu.
    • If you select the
      Mask
      action, Dynamic Data Masking creates a rule for each column according to the masking function that you define. If you do not want to create a rule for any of the columns identified as unprotected, select the column and click the
      -
      icon to remove the column from the list.
    • If you select the
      Block
      action, Dynamic Data Masking creates a rule for each table in the list of unprotected columns. The rule blocks all requests to the identified tables. You can specify an error statement, for example, "Blocked by administrator," before you apply the blocking action. If you do not want to create a rule for any table, select row that contains the table name and click the
      -
      icon to remove the row from the list.
  3. Click
    Save
    in the dialog box.
    The rules appear in the security rule tree.
  4. To save the rules, click the
    Save
    icon in the toolbar, or click
    File
    Save
    .