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 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.