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.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 thedbms_redact
package)