Oracle Database 12c Security Cookbook

Changing the function parameters for a specified column

There are several ways in which you can change an existing redaction policy. In this recipe and the next one, you will:

• Change the function parameters for a specified column (the a_tbl_partial policy, which you created in the recipe Creating a redaction policy when using partial redaction)
• Add a column (commission_pct in the hr.employees table) to the redaction policy EMP_POL (you defined it in the Creating a redaction policy when using random redaction recipe)

Also, it is possible to remove column from the redaction policy, alter the policy expression, and modify the type of redaction for a specified column.

You concluded that the  a_tbl_partial redaction policy doesn't satisfy the requirements ...