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

Last updated on JULY 20, 2024

Applies to:

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

Cause

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