Database Security Products (MOSC)

MOSC Banner

Is there any way to put two different expressions on a single object with DBMS_REDACTION.ALTER_POLIC

edited Aug 26, 2018 5:06AM in Database Security Products (MOSC) 2 commentsAnswered

As i say above, is there any way to do that without having to create a view of the table on which i want to put a different expression with the DBMS_REDACT.ALTER_POLICY?

I have a table with some sensitive data inside, and i want users (attached to two different roles) to see different column in this table.

I'm using ALTER_POLICY to add a column to be redacted but than i need to change the role that can access that table, but once i alter the expression

the role that can access is now a new one and

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