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 (