What must you do to activate the new default value for numeric full redaction?

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?

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.



Leave a Reply 8

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