by Paul Jensen
IN THIS CHAPTER
An Overview of SQL Server Security
Authentication Methods
SQL Server Security: Logins
SQL Server Security: Users
SQL Server Security: Roles
Managing SQL Server Logins
Managing SQL Server Users
Managing Database Roles
Managing SQL Server Permissions
SQL Server Permission Approaches
Object Owners
Using Encryption
Managing SQL Server security involves controlling access to SQL Server and access to the databases and the objects they contain, as well as defining permissions for users who will perform administrative tasks. This chapter will examine the SQL Server security model and demonstrate the various ways to implement security.