Chapter 2. Basic Database Security Principles

After completing this chapter, you will be able to:

  • Design secure access to Microsoft SQL Server

  • Manage access to SQL Server instances

  • Manage access to SQL Server databases

  • Manage access to schemas

  • Manage access to tables and columns

  • Manage access to programmable objects

In Chapter 1, you learned what to store and what not to store in your database. In this chapter, you will learn the basic security concepts that all database developers should know in order to develop secure databases.

Security is a crucial part of most database applications and should not be considered as the last step in the development process. Every element of a database application should be designed with security in mind. You will ...

Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step 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.