Data Redaction
Using this approach users 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 should be a one-to-one mapping between the Account Number and the Original Account Number. The account number should be anonymized.
Note:
The columns V_ACCOUNT_NUMBER, V_CONTRACT_CODE, and V_ORIGINAL_ACCOUNT_NUMBER of the Stage tables allow only - (hyphen) and _ (underscore) special characters.The Data Redaction feature is not supported for Oracle DB version 12.2.0.xx or above.
For more information on GDPR, see the following documents on Oracle Help Center:
Oracle Financial Services Advanced Analytical Applications Infrastructure Application Pack Administration and Configuration Guide