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