Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Access Control
  9. Logs
  10. High Availability
  11. Server Control
  12. Performance Tuning
  13. Troubleshooting
  14. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

Search and Replace Rule

Search and Replace Rule

If you use Sybase with ODBC drivers and have the quoted_identifier option set to off or the query contains a table name with aliases, create a search and replace security rule.
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:
The rule name is Replace. The matcher is Any. The rule action is Search and Replace. The Search Text field contains a double quote ("). The Replacement String field is empty. The processing action is Stop if Applied.

0 COMMENTS

We’d like to hear from you!