O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide by Darril Gibson

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

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