If the quoted_identifier option is set to off or the query contains a table name with aliases, a query sent to the database through Dynamic Data Masking returns an error. You must create a security rule that removes double quotes from the query.

Queries to the database must use a masking rule with the following parameters:

Rule Name

The name of the rule. For example, Replace.

Matcher

Select the Any matcher. The rule applies to all queries sent to the database.

Rule Action

Select the Search and Replace rule action. In the Search Text field, enter a double quote ("). Leave the Replacement String field blank. In the query, the Rule Engine removes double quotes.

Log When Rule is Applied

Select the Log When Rule is Applied check box to create a line in the rule.log file when the Rule Engine applies the rule.

The following image is an example of the search and replace rule: