Stored Procedure Accelerator Guide for Sybase

Back Next

DefMaskRSSym Rule

The DefMaskRSSym rule creates the ExplicitRuleSet, TEMPDB, and TEMPSCHEMA symbols.

Use the ExplicitRuleSet, TEMPDB, and TEMPSCHEMA symbols to define the security rule set, the temporary database, and the temporary schema.

The DefMaskRSSym rule has the following properties:

Name: The name of the rule is DefMaskRSSym.
Matcher: The rule uses the Any matcher.
Rule Action: The rule uses the Define Symbol rule action. Do not change the rule action.
Keep Per Session: Enter No to create symbols that only exist during the current SQL request.

Define the following symbols in the rule action:

ExplicitRuleSet: The ExplicitRuleSet symbol defines the security rule set that contains the masking rules. The symbol value is the name of the rule set. If you want to use the template rules, enter StoredProcMasksTmpl in the Symbol Value field. If you want to use the HR example rule set, enter HRStoredProcMasksRS.
TEMPDB: The TEMPDB symbol defines the name of the temporary database where you want Dynamic Data Masking to create temporary tables and stored procedures. The symbol value is the name of the temporary database. If you do not define the TEMPDB symbol, Dynamic Data Masking uses the default value, tempdb.
TEMPSCHEMA: The TEMPSCHEMA symbol defines the name of the schema in the temporary database where you want Dynamic Data masking to create temporary tables and stored procedures. The symbol value is the name of the temporary schema. If you do not define the TEMPSCHEMA symbol, Dynamic Data Masking uses the default value, dbo.