1312
Whoops (thumbsnap.com)
you are viewing a single comment's thread
view the rest of the comments
[-] rwhitisissle@lemmy.ml 4 points 1 year ago

I would say you can expand that on the following criteria: 1) a lot of people can have read access, but only a few should have write access, and read access should be restricted to specific tables without PII. 2) The people with write access should go through a Change Approval process: they submit the SQL they're going to run and someone else approves or denies it before it can be done. 3) Every piece of SQL that modifies a table should be annotated with a comment and the ticket number in it in which that change was approved. 4) You should be able to rollback any committed change within an hour of it happening.

this post was submitted on 06 Nov 2023
1312 points (98.7% liked)

Programmer Humor

32707 readers
656 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS