O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer 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 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 ...

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