Microsoft® SQL Server™ 2005 Administrator's Companion

Summary

In this chapter you have learned about the principals of user and security management. SQL Server 2005 is similar to SQL Server 2000 in many ways, but the handling of user schema separation is one difference. Keep in mind that the tasks of user and security management are probably among the most important tasks that the SQL Server DBA must perform. This is often an ongoing task for most DBAs because employees join, leave, and change roles within an organization on a regular basis.

Effective security is necessary for ensuring that only authorized personnel or businesses are allowed access to your SQL Server database. Thus, security and user management are key parts of the SQL Server DBA’s job. SQL Server Security has been made easier with ...