An Overview of SQL Server Security
The SQL Server 2008 security model is the best place to start to understand SQL Server security. The model is based on three categories that separate the basic elements of security:
• Principals—Principals are the entities that request security to SQL Server resources. They include Windows users, SQL Server users, and database users.
• Securables—Securables are the SQL Server resources to which permissions can be granted.
• Permissions—Permissions link principals with securables.
Table 11.1 shows the security components contained in each tier of the SQL Server 2008 security model. The columns are ordered from left to right, based on the way security is established.
Table 11.1 SQL Server 2008 Security Components ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
