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.

Start your free trial