Chapter 16. Security: Grant, Revoke, Repeat
It’s your database, you lead the pack. You’ve dedicated a lot of time and attention to turn your database into a champion, and you’d be devastated if anything happened to it. You’ve also had to hand over data access to other people on your team, but what if they insert data incorrectly or modify something they shouldn’t? It’s time to issue clear commands that reinforce security and control who can do what with your data. By creating user accounts and granting specific permissions, you’ll shine as the best handler in the ring.
Coworker conundrum
Unfortunately, one of those new hires, “Larry,” was an undercover agent from a rival summer camp, who purposefully caused a number of data issues.
Avoiding data errors
“Larry” left for his own camp when the summer rolled around, but now Mrs. Murphy has to clean up the camp_calloway_db.
We’ll also need to be careful when we ask new employees to correct “Larry’s” mistakes. They ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access