Table of Contents

Search

  1. Preface
  2. Introduction to the Stored Procedure Accelerator for Oracle
  3. Masking Stored Procedures and User-Defined Table Functions
  4. Stored Procedure Accelerator Setup
  5. Stored Procedure Accelerator Rules

Stored Procedure Accelerator Guide for Oracle

Stored Procedure Accelerator Guide for Oracle

Step 8. Create a Connection Rule

Step 8. 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 Oracle 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 Oracle node in the tree and select
    Action
    Append Rule
    .
    The
    Append Rule
    window opens.
  3. In the
    Append Rule
    window, configure the following parameters:
    Rule Name
    Enter the name of the connection rule.
    Rule Matcher
    Select the Current Target Database matcher.
    Database
    Enter the name of the Oracle database.
    Rule Action
    Select the Use Rule Set action. The Use Rule Set action sends the request to a security rule set.
    Rule Set Name
    Enter the name of the rule set that you want to direct the request to. To use the template rule set, 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 HRStoredProcRS. If you want to create your own rule set, enter the name of the rule set that you create.
    Processing Action
    Select the Continue processing action.
    The following image shows the connection rule:
    The Rule Name is OracleConnectionRule, the rule matcher is Current Target Database, the database is OracleDatabase, the rule action is Switch to Database, the database is StoredProcTmpl, and the processing action is 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
    .

0 COMMENTS

We’d like to hear from you!