3 ms·
Not me, but someone pinged out slack chat asking for us to "please revert". We didn't realize the issue until he admitted that he had run an update on the full
by WrtCdEvrydy 5y ago
Not me, but someone pinged out slack chat asking for us to "please revert".
We didn't realize the issue until he admitted that he had run an update on the full user table (forgot a where clause) and every single email was now being funneled into his email account.
- technion 5y agoThis is a fairly common theme in discussions about outages and production incidents. I'm surprised at this point with various SQL servers there's no simple ACL to the effect of "can run UPDATE, but must include a WHERE clause" or "Can run UPDATE constrained to x rows, will error if more are selected". Obviously there are times where this will be intended but I think "UPDATE ALL ROWS" is a pretty rare requirement.