After completing this chapter, you will be able to:
In Chapter 1, you learned what to store and what not to store in your database. In this chapter, you will learn the basic security concepts that all database developers should know in order to develop secure databases.
Security is a crucial part of most database applications and should not be considered as the last step in the development process. Every element of a database application should be designed with security in mind. You will learn how to grant access to SQL Server instances and databases and how to manage roles at both the database and server levels. Also, you will learn how to use schemas to provide a secure and robust object namespace. Finally, you will learn how to secure access to tables and columns and programmable objects, such as stored procedures and functions.