Chapter 2. Basic Database Security Principles


After completing this chapter, you will be able to:

  • Design secure access to Microsoft SQL Server

  • Manage access to SQL Server instances

  • Manage access to SQL Server databases

  • Manage access to schemas

  • Manage access to tables and columns

  • Manage access to programmable objects

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.




Solid Quality Learning - Microsoft SQL Server 2005. Applied Techniques Step by Step
Microsoft SQL Server 2005: Applied Techniques Step by Step (Pro-Step by Step Developer)
ISBN: 0735623163
EAN: 2147483647
Year: 2006
Pages: 115

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net