Mastering SQL Server 2000 Security

Learn how to protect corporate information by properlydesigning, managing, and maintaining security at the databaselevelSecurity is a primary concern in all aspects of development andIT administration. While locking down networks and erectingfirewalls will always be necessary, so much more can be done toprotect a corporation's most valuable intangible assets: accountingrecords, customer lists, and inventories. Microsoft SQL Server 2000has proven itself to be the fastest and most reliable productavailable for protecting corporate data. No other book covers asthoroughly the subject of security design and implementationstrategies; Mastering SQL Server 2000 Security fills that gap inliterature with practical, hands-on advice.Packed with indispensable design information that can make atightly secured database faster and easier to use, this book isessential reading for both administrators and developers ofdatabases. The authors explain just how much more is possible inthe task of protecting corporate information by properly designing,managing, and maintaining security at the database level.From this book you will:* Learn the ins and outs of SQL Server 2000 Security design* Understand the implementation differences between SQL ServerAuthentication and Windows Authentication* Understand the security options in SQL Server 2000 for Internetapplications* Integrate the security of Windows 2000 (Kerberos) into your SQLServer deployment* Master the security requirements for distributed dataenvironments, such as DTS, replication, linked servers, and datawarehousing

Acknowledgments.Introduction.About the Authors.Chapter 1. Introducing SQL Server Security.Chapter 2. Designing a Successful Security Model.Chapter 3. Exploring Initial Security Parameters.Chapter 4. Establishing Login Security.Chapter 5. Managing Object Security.Chapter 6. Designing Application Security.Chapter 7. Inplementing Front-End Application Security.Chapter 8. Implementing Microsoft's Enterprise DevelopmentStrategy.Chapter 9. Introducing the SQL Server Agent Service.Chapter 10. Managing Distributed Data Security.Chapter 11. Managing Data Transformation Services.Chapter 1. Exploring Analysis Services Security.Chapter 13. Managing Current Connections.Chapter 14.Creating an Audit Policy.Chapter 15. Managing Internet Security.Appendix A: XML for SQL Server 2000.Appendix B. Third-Party SQL Server Security Management Tools.Appendix C: Answers to Review Questions.Index.