Data Redaction

Using this approach, you are provided access rights at the database level. Users with access rights will be able to view the PII data while the same will be redacted for users without access rights.

There must be a one-to-one mapping between the Account Number and the Original Account Number. The account number must be anonymized.

Note:

The V_ACCOUNT_NUMBER, V_CONTRACT_CODE, and V_ORIGINAL_ACCOUNT_NUMBER columns of the Stage tables allow only -, a hyphen, and _, underscore special characters.

The Data Redaction feature is not supported for Oracle DB version 12.2.0.xx or above.