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

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