Administrator Guide

9.9.3
- 9.9.4
- 9.9.2
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Defining the CURRENT_PATH Symbol

If you use the SET SEARCH_PATH = <schema name> command to switch between schema, define the CURRENT_PATH symbol to capture the former command.

Create a security rule with the following properties to set the current schema:

Go to the

Edit Rule

page.

In the

Rule Name

field, enter a name such as

CURRENT_PATH

In the

Matcher

section, perform the following steps:

Set the

Matching Method

property to

Text

Set the

Identification Method

property to

Regular Expression

Enter the following text in the

Text

field:

\s*SET\s*SEARCH_PATH\s*=\s*(.*)

In the

Action

section, perform the following steps:

Set the

Action Type

field to

Define Symbol

Create the CURRENT_PATH symbol.

Enter

\(1)

in the

Symbol Value

column.

Specify

Yes

in the

Keep Per Session

column.

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.

Example

The following image shows an example definition of the CURRENT_PATH symbol on the

Edit Rule

page:

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Defining the CURRENT_PATH Symbol

Defining the CURRENT_PATH Symbol