I'm working on an ETL from Salesforce <--> SQLServer.
Every time I refresh a sandbox, it mangles the e-mail address of every user (example
This is a huge pain because e-mail addresses are used as a unique identifier in part of our database (please, no scolding comments for this; I didn't make the rules).
I tried writing a script that set all users' addresses back to the correct address, but that doesn't work because it sends an e-mail to every user asking to confirm the change, which each user has to open and click the confirmation link in order for the change to take effect. Which is simply impractical.
I understand the need for security, but this is a sandbox, and it exists for no other purpose than as a dev environment for me.
Is there any way to either:
- Disable the auto-mangling of everyone's email address, or
- Disable the requirement for each user to individually approve the e-mail address change back to an actual address?