O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide by David W. Tschanz, J. Steven Jones

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required