My Oracle Support Banner

Data Redaction does not work due to privileges granted to user (Doc ID 2861638.1)

Last updated on MAY 11, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms





Data Redaction is not working on any columns

Tested on one column as below
SQL> BEGIN
 DBMS_REDACT.Add_POLICY(
  object_schema => '<SCHEMA NAME>',
  object_name => '<OBJECT NAME>',
  column_name => '<COLUMN NAME>',
  policy_name => 'REDACT_NAME',
  function_type => DBMS_REDACT.REGEXP,
  e 2 3 4 5 6 7 8 xpression => '1=1',
  regexp_pattern => '(\d\d\d\d)(\d\d\d)(\d\d\d\d)',
  regexp_replace_string => 'XXXXXX\3',
  regexp_position => 1,
  regexp_occurrence => 0,
  regexp_match_parameter => 'i');
END;
/
  9 10 11 12 13 14 15
PL/SQL procedure successfully completed.

SQL>
SQL> select <COLUMN NAME> from <OBJECT NAME>.<COLUMN NAME> where rownum<5;

<COLUMN NAME>
--------------------------------------------------------------------------------
20013021001325
20012100000653
20014021036726
20011021043734

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.