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 has an unsupported data type.
Getting ready
To complete this recipe, you'll need the following:
An existing user who can view data in
OE.CUSTOMERSsample table but doesn't have exempt redaction policy privilege (for example,oe)To connect as a
SYS...
