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.
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 ...