CHAPTER 8 Database Security

In this chapter, you will learn about:

• Security principals

• Permissions

• Securables

• Encryption

Security is always excessive until it's not enough.

—Robbie Sinclair, Head of Security, Country Energy, NSW Australia

The core of database security with SQL Server 2005 focuses on two primary elements:

image Security principals—These are users, roles, or groups that can be granted access.

image Securables—These are resources that can have access regulated. This includes the obvious objects such as databases, stored procedures, ...

Get MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) 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.