Oracle Database 12c Security Cookbook

Creating a redaction policy when using random redaction

Random redaction type is usually used for the number and date-time data types because for these data types, it is hard to make a distinction between the redacted (random) and real data. In this recipe, you will create redaction policy EMP_POL using random redaction type on hr.employees table, column salary, by using SQL*Plus. In the Changing redaction policy recipe, you will modify the EMP_POL redaction policy.

Getting ready

To complete this recipe, you'll need:

• An existing user who can view data in the HR.EMPLOYEES sample table but doesn't have an exempt redaction policy privilege (for example, hr)
• The secmgr user created in the Creating a redaction policy using full redaction recipe or another ...