Stored Procedure Accelerator Guide for Microsoft SQL Server

Stored Procedure Accelerator Guide for Microsoft SQL Server

Configuring the StoredProcMasks Rules

Configuring the StoredProcMasks Rules

Configure the StoredProcMasks rules in the Rule Editor.
  1. Select the ProcMasks1 rule and click
    Action
    Edit
    .
    The
    Edit Rule
    window opens.
  2. Edit the rule properties based on the stored procedure that you want to mask. For example, the HR rule set has a MaskProcDeptEmp rule with masking functions defined for each column.
    The following image shows the rule action parameters in the HR MaskProcDeptEmp example rule:
    The MaskProcDeptEmp rule has masking functions defined for the SALARY, COMM, and LAST_NAME columns for the Proc_Dept_Emp stored procedure.
  3. Click
    OK
    .
    The
    Rule Editor
    closes.
  4. Click
    File
    Update Rules
    to save the security rule.
  5. Select the FuncMasks1 rule and click
    Action
    Edit
    .
    The
    Edit Rule
    window opens.
  6. Edit the rule properties based on the table-valued function that you want to mask. For example, the HR rule set has a MaskFuncJobLoc rule with masking functions defined for each column.
    The following image shows the rule action parameters in the HR MaskFuncJobLoc example rule:
    The MaskFuncJobLoc rule has masking functions defined for the Job_Title and Regional_Group columns for the Func_Job_Loc table-valued function.
  7. Click
    OK
    .
    The
    Rule Editor
    closes.
  8. Click
    File
    Update Rules
    to save the security rules.
  9. Click
    File
    Exit
    to close the
    Rule Editor
    .

0 COMMENTS

We’d like to hear from you!