5.5.1 Redaction Functions

Use functions to define the type of redaction to be applied.

To define a redaction function:

1. Click Data Management Tools > Redaction Framework and select Redaction Functions. The Redaction Functions Summary screen appears.
2. Click Add and provide the following details:
3. Redact Function Name: Specify a name for the function. Example: Email_ID.
4. Description: Provide a description for the function. Example: Function to redact email IDs.
5. Redact Type: Select the redaction type to be applied.
   • Full: You can redact all of the contents of the column data. The redacted value returned to the querying application user depends on the data type of the column. For example, columns of the NUMBER data type are redacted with a zero (0), and character data types are redacted with a single space.
   • Partial Trailing: You can hide or obscure a part of the data at the end of a column value. For example, you can redact a Social Security number with asterisks (*), except for the initial 4 digits.

     Note:

     Only VARCHAR and VARCHAR2 are supported.
   • Partial Leading: You can hide or obscure a part of the data at the beginning of a column value. For example, you can redact a Social Security number with asterisks (*), except for the last 4 digits.

     Note:

     Only VARCHAR and VARCHAR2 are supported.
     • No of characters: (Available only if partial redaction is applied). Specify the number of characters to be redacted.

     Note:

     You can't apply partial redaction to date type columns. Only full redaction is applicable to date type columns.
6. Click Apply.