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.
E
E
E