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 7

Designing SQL Server Object-Level Security

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Develop object-level security.
    • Design a permissions strategy.
    • Analyze existing permissions.
    • Design an execution context.
    • Design column-level encryption.
    • Design security for CLR objects in the database.

images The purpose of SQL Server 2005, or any relational database system, is to store data and make it available for use by applications. All the security that is built into SQL Server 2005 is for the purpose of protecting and ensuring only authorized access to your data. This chapter looks at the lowest level of security—the objects that store and ...

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