Database Security Products (MOSC)

MOSC Banner

How can I achieve row-level Oracle Redaction

Oracle 19c. I read the redaction policies cannot be applied at the row level, correct? So I am trying to find a way to achieve this. I have a column in a table called "protected" and I only want rows with protected=Y to have the redacted data (for example, only redact the SSN data on rows where protected=Y). I understand I cannot do this in the policy expression definition but is it possible to combine Oracle Label Security with Oracle Redaction to achieve this?

I tried creating two views, one with protected=Y and one with protected=N and applying the redaction policy only to the protected=y view but when I attempt to combine these views with a union all I get a redaction error.

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