Writing Stored Procedures for Microsoft SQL Server

Chapter 9. Providing Security for Stored Procedures

IN THIS CHAPTER

• Security basics

• SQL server security

• Stored procedures as a security mechanism

• Application security

• Ownership chains

Most developers start to think about security after they design and code their applications. Although providing security for your applications is always important, starting to do so after you design the application isn't the best time. You should start thinking about security during the design process. If you start early, your application will be designed in a way that enables you to provide security easily. This chapter concentrates on providing security for your application by covering the following points:

• SQL Server security

• Stored procedures as a security mechanism ...