CHAPTER 28
Principals and Users
Microsoft uses a set of terminology to describe SQL Server security functionality, which separates the security architecture into the following:
- Principals: These are objects (for example, a user login, a role, or an application) that may be granted permission to access particular database objects.
- Securables: These are objects (a table or view, for example) to which access can be controlled.
- Permissions: These are individual rights, granted (or denied) to a principal, to access a securable object.
Principals are the topic of this chapter, and securables and permissions are discussed in the ...
Get SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach 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.
