Creating a redaction policy when using full redaction
In this recipe, you will create a redaction policy on the income_level
column (on the income_level
column on the CUSTOMERS
table in the sample schema OE
), find the default values (for full redaction) for different data types, and change the default value for the varchar2
data type.
Note
You may consider data about customer address to be sensitive. Unfortunately, you can't create a redaction policy on the CUST_ADDRESS
column (the table CUSTOMERS
in the sample schema OE
) because its data type is not supported (its data type is TYPE
, which is not a literal value, so it can't be redacted). If you try to create a redaction policy, you will receive the following error: ORA-28073
. The column CUST_ADDRESS ...
Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.