Prev Question
Next Question

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 the
current database instance. After you modify a value, you must restart the database for it to take effect.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *