Add a column to the redaction policy

You have to modify the existing redaction policy in order to redact more than one column in the table. In the table HR.EMPLOYEES, besides the column SALARY, you want to redact the column COMMISSION_PCT. You will modify the redaction policy EMP_POL. You decide that you want to use full redaction type for the column COMMISSION_PCT.

Note

Note that in the same redaction policy (in this case, EMP_POL) the different "protected" columns can use different redaction types (in this case, random and full redaction).

Getting ready

Before doing this recipe, you should have completed the Creating redaction policy when using random redaction recipe. You will use the secmgr user you created in the Creating redaction policy when using full redaction recipe.

How to do it...

1. Connect to the database as the secmgr user and alter the EMP_POL policy:

   $ sqlplus secmgr
   SQL> BEGIN
     2  DBMS_REDACT.ALTER_POLICY(
     3  object_schema   => 'HR',
     4  object_name     => 'EMPLOYEES...