Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Dynamic Data Masking 9.9.2
  • All Products

Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Before You Install or Upgrade
  4. Product Installation
  5. Upgrade from Dynamic Data Masking 9.9.1
  6. After You Install or Upgrade
  7. Uninstallation

Installation and Upgrade Guide

Installation and Upgrade Guide

Back Next

Create Rule Sets for the Microsoft SQL Server Service

Create Rule Sets for the Microsoft SQL Server Service

If you defined additional Microsoft SQL Server databases in the Microsoft SQL Server database
Edit
 window, you must complete the following steps:
  1. Export the default rule set and the rule sets associated with the Microsoft for SQL Server databases you defined in the Microsoft SQL Server Databases section of the database
    Edit
     window. In the Management Console, select a rule set and click
    Tree
    Security Rule Set
    .
    The
    Rule Editor
     window appears.
  2. Click
    Action
    Export
    .
    The
    Export
     window appears.
  3. Navigate to the directory where you want to save the rule set and click
    Export
    .
  4. Click
    File
    Exit
     to close the
    Rule Editor
    .
  5. In the Management Console tree, select a domain node and click
    Tree
    Security Rule Set
    .
    The
    Add Rule Set
     window appears.
  6. Enter a rule set name in the Rule Set Name field and click
    OK
     to close the
    Add Rule Set
     window.
  7. In the Management Console tree, select the MasterRuleSet security rule set and click
    Tree
    Security Rule Set
    .
    The
    Rule Editor
     window appears.
  8. Click
    Action
    Append Rule
    .
    The
    Append Rule
     window appears.
  9. Specify the following properties in the
    Append Rule
     window:
    Property
    Value
    Rule Name
    MasterFolder
    Matcher
    Any
    Rule Action
    Folder
    Processing Action
    Stop if Applied
  10. Click
    OK
     to close the
    Append Rule
     window.
  11. Click
    File
    Update Rules
     to save the rule folder.
  12. In the Rule Editor, select the MasterFolder rule folder and click
    Action
    Import
    .
    The
    Import
     window appears.
  13. Navigate to the folder where you exported the Default Rule Set. Select the rule set and click
    Import
    .
  14. Click
    File
    Update Rules
     to save the rules.
  15. Create a rule folder for each database you defined in the Microsoft SQL Server database
    Edit
     window.
  16. Click
    Action
    Append Rule
    .
    The
    Append Rule
     window appears.
  17. Specify the following properties in the
    Append Rule
     window:
    Property
    Value
    Rule Name
    Enter the name of the database.
    Matcher
    Symbol Matcher
    Symbol Name
    AUTH_CURRENT_DATABASE
    Text
    Enter the name of the database. The Text property is case sensitive.
    Rule Action
    Folder
    Processing Action
    Stop if Applied
  18. Click
    OK
     to close the
    Append Rule
     window.
  19. Click
    File
    Update Rules
     to save the rule folder.
  20. In the
    Rule Editor
    , select the rule folder you created and click
    Action
    Import
    .
    The
    Import
     window appears.
  21. Navigate to the folder where you exported the rule set for the database. Select the rule set and click
    Import
    .
  22. Drag the MasterFolder security rule folder to the bottom of the rule tree.
  23. Click
    File
    Update Rules
     to save the rules.
0 COMMENTS
We’d like to hear from you!