Why This Chapter Is Important
Security is necessary to prohibit access to unauthorized users and to ensure that authorized users have only the rights that you want them to have. SQL Server security is very robust and offers you several alternatives for your security model. This chapter begins by introducing you to SQL Server security. It talks about both authentication and permissions validation. It then talks about a special option available for SQL Server security referred to as an application role. Finally, you'll learn how Access Security interacts with SQL Server security in the applications that you build.