After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
————————-
0
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full;
NUMBER VALUE
————————
-1
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?
A.
Re-enable redaction policies that use FULL data redaction.
B.
Re-create redaction policies that use FULL data redaction.
C.
Re-connect the sessions that access objects with redaction policies defined on them.
D.
Flush the shared pool.
E.
Restart the database instance.
Explanation:
About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction
(DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the
DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in thecurrent database instance. After you modify a value, you must restart the database for it to take effect.