Chapter Essentials

The Importance of Establishing Baselines Security baselines provide the minimum security configuration settings required to implement a given system type. As a best practice, you should create a security baseline for SQL Server 2008 servers in your environment. Once the baseline is implemented, you can then harden each SQL Server 2008 server for its specific intent.

Implementing Least Privilege Least privilege simply says that a user or system should never have more access than that required of the user or system to perform its intended actions. Least privilege is implemented by using authorization schemes. SQL Server 2008 supports authorization through object and statement permissions. Object permissions are used to protect ...

Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.