Table of Contents

Search

  1. Preface
  2. Introduction to the Stored Procedure Accelerator for Oracle
  3. Masking Stored Procedures and User-Defined Table Functions
  4. Stored Procedure Accelerator Setup
  5. Stored Procedure Accelerator Rules

Stored Procedure Accelerator Guide for Oracle

Stored Procedure Accelerator Guide for Oracle

MATCH_FUNCTION Symbols

MATCH_FUNCTION Symbols

You can create MATCH_FUNCTION and MATCH_FUNCTION_PARAMS symbols and a user-defined function that determine whether to mask a stored procedure.
By default, the DefMaskRSSym rule contains ExplicitRuleSet and ORACLE_DDM_TEMPDB symbols. You can optionally define additional symbols that use a PL/SQL function to determine whether to mask the stored procedure.
To use the additional symbols, you must create a decision making function that determines whether to mask the stored procedure. The function must return 0 or 1. If the function returns 1, Dynamic Data Masking masks the stored procedure. If the function returns 0, Dynamic Data Masking does not mask the stored procedure.
You can define the following symbols in the DefMaskRSSym rule:
MATCH_FUNCTION
The MATCH_FUNCTION symbol identifies the name of the decision making function.
In the
Symbol Name
field, enter MATCH_FUNCTION. In the
Symbol Value
field, enter the fully qualified name of the PL/SQL decision making function.
MATCH_FUNCTION_PARAMS
The MATCH_FUNCTION_PARAMS symbol defines the number of arguments in the original stored procedure that you want to pass to the decision making function.
In the
Symbol Name
field, enter MATCH_FUNCTION_PARAMS. In the
Symbol Value
field, enter the number of arguments in the original stored procedure that you want to pass to the decision making function. The count starts from the first argument.

0 COMMENTS

We’d like to hear from you!