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