Stored Procedure Accelerator Guide for Sybase

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 names.

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

.*Proc_Dept_Emp.*

The following image shows the MatchProcsNamesFolder rule matcher parameters:

The MatchPRocNamesFolder rule uses theText matcher and has .*Proc_Dept_Emp.* 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.

Define the following symbols:

ExplicitRuleSet: Enter ExplicitRuleSet in the Symbol Name field and the name of the rule set that contains the masking rules in the Symbol Value field. For the template rule sets, enter StoredProcMasksTmpl. If you want to use the HR example rule set, enter HRStoredProcMasksRS.
TEMPDB: Enter TEMPDB in the Symbol Name field and the name of the temporary database in the Symbol Value field, such as TempDB. If you do not define the TEMPDB symbol, Dynamic Data Masking uses the default value, tempdb.
TEMPSCHEMA: Enter TEMPSCHEMA in the Symbol Name field and the name of the temporary schema in the Symbol Value field, such as TempSchema. If you do not define the TEMPSCHEMA symbol, Dynamic Data Masking uses the default value, dbo.

The following image shows the DefMaskRSSym rule action properties:

The DefMaskRSSym uses the Define Symbol rule action. The Symbol Name is ExplicitRuleSet, the Symbol Value is StoredProcMasksTmpl, and the Kep Per Session value is No..

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 ProcMaskerSybase.

The following image shows the MaskProcs rule action parameters: