Managing SQL Server Security

SQL Server provides built-in security and data protection. Its security features are trustworthy and relatively easy to administer. By taking advantage of SQL Server's security features, you can create a secure database that prevents unauthorized access and allows data modification to occur in a controlled and orderly manner.

Levels of Security

The term security is a broad term that carries different meanings depending on how it is applied. It can be applied to the following levels (see Figure 9.8):

  • Operating system— To connect to the server, a user typically must go through some type of operating system login routine that validates system access.

  • SQL server— To connect to SQL Server, the user must have a valid SQL ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.