Using the Replace Table Rule Action to Implement Row-Level Security

Back Next

Step 4. Create the Define Symbol Rule

Create a Define Symbol rule that defines a symbol for the Sales department identification number.

In the Rule Editor, select the security rule folder that you created and click

Action

Append Rule

The

Append Rule

window appears.

Configure the following parameters for the Define Symbol rule:

Rule Name: Enter the name of the rule. In this example, the rule name is DefineSymbol.
Description: Enter an optional description of the rule.
Matcher: Select the Any matcher. The Rule Engine applies the rule to all incoming requests.
Action: Select the Define Symbol action. In the Symbol Definition box, define the following parameters:
Symbol Name
. The name of the symbol. In this example, the symbol name is DepartmentID.
Symbol Value
. The value of the symbol. In this example, the symbol value is 100, which is the Sales department identification number in the DEPARTMENT_ID column of the EMPLOYEES table.
Keep per Session
. Enter Yes. The symbol becomes a global symbol for the session and exists until the user disconnects from the database.
Processing Action: Select the Continue processing action. The Rule Engine continues to the next rule in the tree.
Log When Rule is Applied: To include information in the log files about when the Rule Engine applies the rule, select the Log When Rule is Applied parameter.