Re:Salesforce enables ‘modify all’ in user profiles
by megous on Saturday May 18, 2019 @08:15AM
(#19946987)
If you fear this, you can put it into script like this:
BEGIN; UPDATE... SELECT for verification ROLLBACK;
And then just change ROLLBACK to COMMIT, after you're sattisfied. There's no need to do it interactively.
I always recommend that you are wrapping calls in transactions if you are touching prod data. I only left the WHERE clause of my update query off once in my life before I started doing that.