Stored Procedure Accelerator Guide for Microsoft SQL Server

Stored Procedure Accelerator Guide for Microsoft SQL Server

Step 4. Create a Connection Rule

Step 4. Create a Connection Rule

Create a connection rule that directs SQL requests to the StoredProcTmpl rule set.
  1. Select the Dynamic Data Masking service node for Microsoft SQL Server that you created in the Management Console tree and click
    Tree
    Connection Rules
    .
    The
    Rule Editor
    opens.
  2. In the
    Rule Editor
    , select the DDM for SQL Server node in the tree and select
    Action
    Append Rule
    .
    The
    Append Rule
    window opens.
  3. In the
    Append Rule
    window, configure the following parameters:
    Parameter
    Description
    Rule Name
    The logical name of the rule that appears in the rule tree. Enter the name of the connection rule.
    Rule Matcher
    Defines the criteria that the Rule Engine uses to identify a match. Select Current Target Database.
    Database
    Defines the target database name. Enter the name of the database.
    Rule Action
    Defines the action that the Rule Engine applies to incoming connections. Select Use Rule Set.
    Rule Set Name
    Defines the rule set that the Use Rule Set rule action sends the request to. Enter the name of the rule set that you want to direct the request to. To use the template rule sets, enter StoredProcTmpl.
    The Rule Set Name that you enter is the name of the rule set that contains the Define Symbol and Java Action security rules. If you want to use the HR example rule set, enter HRStoreProcRS. If you want to create your own rule set, enter the name of the rule set that you create.
    Processing Action
    Determines how the Rule Engine processes the connection after the Rule Engine applies the connection rule. Select Continue.
  4. Click
    OK
    .
    The rule appears in the
    Rule Editor
    .
  5. Select
    File
    Update Rules
    to save the connection rule.
  6. Select
    File
    Exit
    to close the
    Rule Editor
    .
The following image shows the connection rule:
The Rule Name is StoredProc Connection rule, the rule matcher is Current Target Database, the Database is MS SQL Server Database, the rule action is Use Rule Set, the Rule Set Name is StoredProcTmpl, and the processing action is Continue.

0 COMMENTS

We’d like to hear from you!