Full Data Redaction to Redact All Data

Full data redaction redacts the entire contents of a specified column of a table or view.

By default the output is displayed as follows:

• Character data types: The output is a single space.

• Number data types: The output is a zero (0).

• Date-time data types: The output is set to the first day of January, 2001, which appears as 01-JAN-2001.

When you run the DBMS_REDACT.ADD_POLICY procedure, to set the function_type parameter setting for full redaction, you enter the following setting:

function_type    => DBMS_REDACT.FULL

Full redaction is the default and is used whenever a Data Redaction policy specifies the column but omits the function_type parameter setting.

You can use the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to change the full redaction output to different values. You can find the current values by querying the REDACTION_VALUES_FOR_TYPE_FULL data dictionary view.

Related Topics

• Syntax for Creating a Full Redaction Policy

• Altering the Default Full Data Redaction Value

• Oracle AI Database Reference

• Oracle AI Database PL/SQL Packages and Types Reference