I want to mask data of a specific column in the database. I am using two rules.
1. Access Rule - S-GATE Attach - If the user is within a user group, table is in the list of objects and column is within a group of fields.
2. Extrusion Rule - Redact - If the user is within a user group, and data pattern is ([aA0-zZ9].?) This means all the data in the column is masked with replacement character *.
We have Oracle 11g. HP-UX 11.31 64-bit. Character set UTF-8(AL32UTF8). However, these rules are not working. masking is not happening of the data.
Datatype of the column, which is supposed to be masked is VARCHAR2.