In this chapter, you will learn about:
• Security principals
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:
Security principals—These are users, roles, or groups that can be granted access.
Securables—These are resources that can have access regulated. This includes the obvious objects such as databases, stored procedures, ...