Database Administration (MOSC)

MOSC Banner

Why my Oracle Data Redaction isn't applying the correct expression?

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

Production Version 19.3.0.0.0


I noticed a malfunction in Oracle Data Redaction and I can't figure out what is going on. When I add a policy to a table, the expression that defines which users will be affected by it is extended to other columns, even if I specify a different expression. A minimum implementation of the problem follows:


create user usr1 identified by senha quota 5M on users;


grant create session, create table to usr1;


grant execute on dbms_redact to usr1;


conn usr1/senha@orclpdb

-- creating table for test purpose

CREATE TABLE Clientes (

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