Chapter 13. Administering SQL Server Security

Important changes have been introduced with SQL Server 2005 to allow a much more effective method of design, implementation, and administration of security across resources and services provided by the SQL environment. Security permissions can be defined on a wide range of objects, from network endpoints that facilitate client communication, to execute permissions on a stored procedure, even down to the cell level within a table. Complex security implementations can be efficiently controlled with granular role-based authorization and database security schemas.

Administering SQL security is a key database administrator task that normally begins immediately following the hardening of the system, and ...

Get Microsoft® SQL Server 2005 Management and Administration 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.