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 to Specify the Procedure Call and Process the Result Set

Step 1. Create a Security Rule Set to Specify the Procedure Call and Process the Result Set

The first rule set contains a rule that identifies the procedure call as a valid procedure call with a result set that you want to mask. You can use the Procedure Call matcher in this rule to give the name of the stored procedure, or you can use other matchers, for example the From Clause or Text matchers. The matcher works at the level of the SQL query. Use the Process Result action to specify the name of the second rule set that you create.
  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, "SQLServerRulesXML."
  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
    , you can select
    Procedure Call
    or another matcher to identify the procedure call. If you select Procedure Call, provide the name of the stored procedure.
  10. For
    Action Type
    , select
    Process Result
    .
  11. For
    Ruleset Name for Resultset
    , give the name of the next rule set that you will create to process the result set. For example, "MaskEmpXMLRS."
  12. For
    Processing Action
    , select
    Stop if Applied
    .
  13. To create the rule, click
    OK
    .
  14. Select
    File
    Update Rules
    to save the rule in the rule tree.