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'