Stored Procedure Accelerator Guide for Microsoft SQL Server

9.9.2
- 9.9.3
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Configuring the StoredProc Rules

Configure the StoredProc rules in the

Rule Editor

Select the MatchProcNamesFolder rule and click

Action

Edit

The

Edit Rule

window opens.

In the Text field of the matcher, replace "proc name 1," "proc name 2," and "proc name 3" with stored procedure or table-valued function names.

For example, you might enter the following text in the Text field:

.*Proc_Dept_Emp.*|.*Func_Job_Location.*

The following image shows the MatchProcsNamesFolder rule matcher parameters:

The MatchPRocNamesFolder rule uses theText matcher and has .*Proc_Dept_Emp.*|.*Func_Job_Location.* entered in the Text field.

Click

The

Rule Editor

closes.

Click

File

Update Rules

to save the security rule.

Select the DefMaskRSSym rule and click

Action

Edit

The

Edit Rule

window opens.

In the Value field of the rule action, enter the name of the rule set that contains the masking rules. For the template rule sets, enter StoredProcMasksTmpl. If you want to use the HR example rule set, enter HRStoredProcMasksRS.

The Symbol Name must be ExplicitRuleSet.

The following image shows the DefMaskRSSym rule action properties:

The DefMaskRSSym uses the Define Symbol rule action. The Symbol Name is ExplicitRuleSet and the Value is StoredProcMasksTmpl.

Click

The

Rule Editor

closes.

Click

File

Update Rules

to save the security rule.

Select the MaskProcs rule and click

Action

Edit

The

Edit Rule

window opens.

In the rule action Class Path field, enter the file path of the stored procedure accelerator .jar files, separated by a semicolon (;).

You can find the .jar files in the following directory:

<Dynamic Data Masking installation>\Accelerators\StoredProcedureMasking\lib

For example, you might enter:

C:\Program Files\Informatica\DDM\Accelerators\StoredProcedureMasking\lib\StoredProcedureMasking.jar;C:\Program Files\Informatica\DDM\Accelerators\StoredProcedureMasking\lib\MultipleStatementMasking.jar

The Class Name must be ProcMaskerSQLServer.

The following image shows the MaskProcs rule action parameters: