After implementing full Oracle Data Redaction, you change the default value for the data NUMBER type as follows: After changing the value, you notice that FULL redaction continues to redact numeric…

Question

Exhibit

Options

• ARe-enable redaction policies that use FULL data redaction.
• BRe-create redaction policies that use FULL data redaction.
• CRe-connect the sessions that access objects with redaction policies defined on them.
• DFlush the shared pool.
• ERestart the database instance.

• A
  4% (3)
• B
  1% (1)
• C
  3% (2)
• D
  9% (6)
• E
  83% (57)

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. *The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an *UPDATE_FULL_REDACTION_VALUES Procedure This procedure modifies the default displayed values for a Data Redaction policy for full *After you create the Data Redaction policy, it is automatically enabled and ready to redact data. *Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods: /Full redaction. /Partial redaction. /Regular expressions. /Random redaction.

No community discussion yet for this question.