SQL Server® 2008 Administration: Instant Reference

7.1. Implement User Security

The security infrastructure in SQL Server 2008 is very similar to the security model used in other Microsoft platforms and products. The good news, then, is that if you are accustomed to the Microsoft way of managing security, you are halfway there. To get the rest of the way requires that you apply the security model to the specific nuances of working in a database environment.

To design a good security model, you must understand how the model is organized and be able to identify its architectural characteristics. Then you can use this information to define and implement a security model that will provide the correct balance of convenience and protection, which is the hallmark of any flexible security model. In ...