Scripts + Steps to Scramble Backup Data

Scripts to Scramble Backup Data

GOAL: Scramble sensitive information in backup data such as SIN, Surname and Bank Account. 

FIX: Set SIN as NULL, and default values to Surname and EMP_BANK_ACCOUNT under EC_EMPLOYEE table

IMPORTANT NOTE: This script is not to be run in PROD or TEST. 

This should ONLY be run in an UNUSED ENVIRONMENT that has been updated with a recent copy of PROD data. 

This way the newly restored data from Production can be scrambled for privacy and re-backed up for distribution. 

update EC_EMPLOYEE

set SOCIAL_INSURANCE_NUMBER = NULL, SURNAME = 'EMPLOYEE', EMP_BANK_ACCOUNT = '1111111'