Oracle Redaction fails across Database Links
Oracle Database - Enterprise Edition
Version11.2.0.4
IBM AIX on POWER Systems (64-bit)
When Alphnumeric Redaction is turned on and we are selecting over database links - the data being compared in the where clause is effectively 'redacted'. By that I mean that it's behaving like a select statement and returning it to the engine as already redacted, as you would see if you had simply selected the data.
My understanding is that redaction should not be applied at the where clause and especially not in joins.
E.g.
select
rownum, a.id, b.id, a.name,b.name, length(a.name),length(b.name)