Hello All,
We have some tables with Encrypted PII data. So we can't extract and move the data to the test regions, unless the REAL data is Masked.
If we mask the encrypted data, during decryption, it wont give expected results.
Is there a way to decrypt the data from DB and Mask it, on the FLY.
We have the workaround like Decrypt the data to another DB of same structure and then use OPTIM on that table to extract an mask.
Is there another way to do this on the FLY ?
Suggestions/Comments are much appreciated.
Regards,
Joseph Ravindran
American Express made the following annotations
"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information
included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."
American Express a ajouté le commentaire suivant le
Ce courrier et toute pièce jointe qu'il contient sont réservés au seul destinataire indiqué et peuvent renfermer des renseignements confidentiels et privilégiés. Si vous n'êtes pas le destinataire prévu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pièce jointe est interdite. Si vous avez reçu cette communication par erreur, veuillez nous en aviser par courrier et détruire immédiatement le courrier et les pièces jointes. Merci.