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. Configuration for MicroStrategy
  9. Access Control
  10. Logs
  11. High Availability
  12. Server Control
  13. Performance Tuning
  14. Troubleshooting
  15. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

Define the CURRENT_SCHEMA Symbol

Define the CURRENT_SCHEMA Symbol

If you want to query a table with the
set schema
command and without a table prefix, you must create a security rule to define the CURRENT_SCHEMA symbol.
Create a security rule with the following properties to set the current schema:
Matcher
Select the Text matcher. In the Text matcher, select the Regular Expression Identification Method.
Enter the following regular expression in the Text field:
\s*SET\s+(CURRENT\s+)?SCHEMA\s*(=)?\s*('|")?(\w+)('|")?(.*)
If you use this regular expression, a database request with the following format will fail:
SET CURRENT_SCHEMA 'ABC'
Rule Action
Select the Define Symbol action. Define the following rule action parameters:
  • Symbol Name: CURRENT_SCHEMA
  • Symbol Value: \(4)
  • Keep Per Session: Yes
The following image shows the rule properties:
The rule uses the Text matcher and the Define Symbol rule action.

0 COMMENTS

We’d like to hear from you!