CHAPTER 8Security

In this chapter, you will learn about:

• Server security basics

• Authentication modes

• Security principals such as server logins and database users

• Server roles and database roles

• Securables such as tables, VIEWs, and stored procedures

• Permissions

• Encryption

Never underestimate the time, expense, and effort an opponent will expend to break a code.

—Robert Morris

It's been said that the only way to keep your computer 100 percent safe and secure is to power it down, unplug it from the network, and bury it in the sand. Safe and secure? Yes. Usable? No. When it comes to security, we must constantly strive for a balance between security and usability by practicing risk management.

In this chapter, we'll cover some basic ...

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