Chapter 7. Authorization: what are you allowed to do?
We’re on the second “A” of security: after authenticating you so that it knows who you are, SQL Server needs to decide what you’re allowed to do. By default, the answer is “Nothing.” You have to be granted permission to do things, both at the server level and within individual databases, and that’s what this chapter is all about.
7.1. Understanding SQL Server permissions
SQL Server has an extremely granular system of permissions that determines who is allowed to do what. Remember, the authentication process tells SQL Server who you are; these permissions then determine what you can do.
There are server-wide permissions that govern your ability to do things such as create new databases ...
Get Learn SQL Server Administration in a Month of Lunches now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
