The Stored Procedure Accelerator for Microsoft SQL Server contains template rules and sample rules that you can edit or copy to create rules based on the stored procedures and table-valued functions in the database.
To use the accelerator, you must create a connection rule and two rule sets. The connection rule directs requests to the first rule set. The first rule set contains rules to set up the accelerator. The second rule set contains masking rules. You can import the accelerator rule sets and configure the rules based on the stored routines in the database.
You can find the .xml files that contain the accelerator rule sets in the following location:
<Dynamic Data Masking installation>\Accelerators\StoredProcedureMasking\rules\SQLServer
The SQLServer_StoredPRocMasksRSTmpl.xml and SQLServer_StoredProcRSTmpl.xml files contain the template rule sets. You can import the template rule sets and configure the rules to mask stored procedures and table-valued functions.
The SQLServer_HRStoredProcRS.xml and SQLServer_HRStoredPRocMasksRS.xml files contain the example HR rule sets. You can view the example rules to see how a complete rule set looks.