Database Security Products (MOSC)

MOSC Banner

How can I mask a column or redact the data, Not setting data to NULL combination includes row condit

edited Apr 15, 2016 5:05AM in Database Security Products (MOSC) 1 commentAnswered

I have a requirement to show data from single table. Some users must not see certain columns for certain rows.

CREATE table job
(id number not null,
regular_data varchar2(10),
data_security_flag varchar2(1) not null,
sensitive_data varchar2(10))

data_security_flag will have check constraint - values in ('N','C','S')

Some users (with "N" access) can see all rows all columns
Others (with "C" access) can see all rows, but not "sensitive_data" on rows where data_security_flag = 'N'

Our requirement is complicated -- for the "others" -- we need to show something in the hidden column.

Tagged:

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