Chapter 6

Designing SQL Server Service-Level Security

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Design SQL Server service-level security.
    • Specify logins.
    • Select SQL Server server roles for logins.
    • Specify a SQL Server service authentication mode.
    • Design a secure HTTP endpoint strategy.
    • Design a secure job role strategy for the SQL Server Agent Service.
    • Specify a policy for .NET assemblies.
  • Design database-level security.
    • Specify database users.
    • Design schema containers for database objects.
    • Specify database roles.
    • Define encryption policies.
    • Design DDL triggers.

images SQL Server runs on top of a Windows host, but it is a server operating ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design 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