SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

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