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 user who can create redaction policies (has execute on the dbms_redact package)

How to do it...

1. Connect to the database as a user who has the SELECT privilege on the HR.EMPLOYEES table or the SELECT ANY TABLE privilege (for example, hr user):

   $ sqlplus...