Database Security Products (MOSC)

MOSC Banner

Oracle Redaction fails across Database Links

edited Feb 15, 2023 2:05PM in Database Security Products (MOSC) 3 commentsAnswered

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)

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