Database Security Products (MOSC)

MOSC Banner

Redaction on view with UNION causes ORA-28094: SQL construct not supported by data redaction

edited Apr 6, 2018 11:08AM in Database Security Products (MOSC) 2 commentsAnswered

Redaction of 9 digit SSNs.',

   column_description     => 'pi_ssn contains SSNs for the member.');

END;

/

Query view:

SQL> select * from redaction_schema.all_test;

select * from redaction_schema.all_test

                               *

ERROR at line 1:

ORA-28094: SQL construct not supported by data redaction

Query using inline union fails too:

SQL> select * from (

  2       select * from redaction_schema.test_red

  3       union

  4       select * from redaction_schema.test_nored

  5                );

     select * from redaction_schema.test_nored

                                    *

ERROR at line 4:

ORA-28094: SQL construct not supported by data redaction

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center