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

Step 1. Create a Security Rule Set with a Procedure Call and Process Result Rule

Step 1. Create a Security Rule Set with a Procedure Call and Process Result Rule

The first rule set that you create contains a rule to identify the procedure call and process the result set with the following security rule set.
  1. To create a security rule set, click on a domain node in the rule tree.
  2. Click
    Tree
    Add Rule Set
    .
    The
    Add Rule Set
    window appears.
  3. Enter a name for the security rule set, for example, "SQLServerRules."
  4. Click
    OK
    .
    Within this rule set, create a rule to specify the stored procedure call and process the result set through the following rule set.
  5. In the Management Console, click the security rule set that you created in the previous step.
  6. Select
    Tree
    Security Rule Set
    .
    The
    Rule Editor
    appears.
  7. Click
    Action
    Append Rule
    .
    The
    Append Rule
    window appears.
  8. Enter a name for the rule, for example, "MaskEmpLastName."
  9. For the
    Matching Method
    , select
    Procedure Call
    .
  10. For
    Procedure Name
    , give the exact name of the stored procedure with the result set that you want to mask.
  11. For
    Action Type
    , select
    Process Result
    .
  12. For
    Ruleset Name for Resultset
    , give the name of the next rule set that you will create. For example, "MaskEmpResultSet."
  13. For
    Processing Action
    , select
    Stop if Applied
    .
  14. To create the rule, click
    OK
    .
  15. Select
    File
    Update Rules
    to save the rule in the rule tree.