VIII.3.1. The Value of Security

To a database administrator already overwhelmed with daily tasks, setting up a well-designed security plan can sometimes seem more trouble than it's worth. Therefore, it's quite fair to ask whether there's value in making the effort. If you can answer, "Yes" to any of the following questions, then you'll eventually be glad you took the time and implemented a decent security plan:

  • Will your database hold sensitive information?

  • Will multiple people work with your data?

  • Might any of the people who interact with your data ever part ways with your organization in a less-than-amicable manner?

  • Will other computers connect to your database?

  • Might any of these external computers be compromised?

  • Will your database server be available over a local network or the Internet?

Chances are that at least one of these will apply to most readers. With that in mind, it's time to see how to get started setting up the right security plan for your database.

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® 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.