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

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

Back Next

Test the Rule Set

Verify that you created the connection and security rules correctly.

After you create the rule set, you can use the Security Rule Set Simulator to verify that the rules correctly restrict and mask data. To use the simulator, select the root security rule set node and click

Action

Security Rule Set Simulator

. For more information about the Security Rule Set Simulator, see the

Dynamic Data Masking User Guide

You can run a query on the database to view the result set. The following image shows the result set of a query from SQL Developer:

The query SELECT * FROM HR.EMPLOYEES only returns rows that have a value of 100 in the DEPARTMENT_ID column. The SALARY column returns NULL values.

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

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

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

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

Test the Rule Set

Test the Rule Set