Administrator Guide

Back Next

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: