Head First SQL, 2nd Edition

Chapter 15. Security: Grant, Revoke, Repeat

A Note for Early Release Readers

With Early Release ebooks, you get books in their earliest form—the author’s raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 15th chapter of the final book. Please note that the GitHub repo will be made active later on.

If you have comments about how we might improve the content and/or examples in this book, or if you notice missing material within this chapter, please reach out to the editor at [e-mail].

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 ...