Chapter 10
Designing a Strategy to Manage and Maintain Database Security
MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:
- Maintain a server-level security strategy.
- Design a strategy to audit Windows account permissions.
- Design a strategy to audit SQL Server service access.
- Maintain a strategy to assign the appropriate minimum level of privileges.
- Maintain an encryption strategy that meets business requirements.
- Design a strategy to apply service packs and security updates.
- Configure the surface area.
- Maintain a user-level security strategy.
- Verify the existence and enforcement of account policies.
- Verify SQL Server login authentication.
- Verify permissions on SQL Server roles and accounts.
For a DBA, it is useful to be able to set ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide 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.