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.
To complete this recipe, you'll need:
- An existing user who can view data in the
HR.EMPLOYEESsample table but doesn't have an exempt redaction policy privilege (for example,
secmgruser created in the Creating a redaction policy using full redaction recipe or another ...