Stored Procedure Accelerator Guide for Microsoft SQL Server

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

Back Next

StoredProcMasks Rule Set

The StoredProcMasks rule set contains masking rules for stored procedures and table-valued functions.

You can add as many masking rules to the StoredProcMasks rule set as required. You must create a separate rule for each stored procedure and table-valued function. The predefined rule set contains two rules that show you how to mask a stored procedure and a table-valued function.

The StoredProcMasks template rule set is the SQLServer_StoredPRocMasksRSTmpl.xml file in the accelerator directory. To use the template rules, create a rule set with the name StoredProcMasksTmpl and import the rules into the rule set.

The StoredProcMasks example HR rule set is the SQLServer_HRStoredProcRS.xml file in the accelerator directory. To use the example rules, create a rule set with the name HRStoredProcMasksRS and import the rules into the rule set.

You can also create a rule set with any name and create masking rules in the rule set based on the template rules and example rules.

You must identify the StoredProcMasks rule set name in the DefMaskRSSym rule when you define the symbol value. If you change the name of the StoredProcMasks rule set, update the Value field in the DefMaskRSSym rule.

Stored Procedure Accelerator Rules

ProcMasks1 Rule

FuncMasks1 Rule

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal