Microsoft® SQL Server™ 2005: Applied Techniques Step by Step

Managing Access to Programmable Objects

Programmable objects, such as stored procedures and user-defined functions, have their own security context. Database users need permissions in order to execute stored procedures, functions, and assemblies. Once the database engine has checked for permission to execute a programmable object, it then checks permissions for operations performed inside programmable objects. When database objects access each other sequentially, the sequence forms an ownership chain. You will learn about ownership chains later in this chapter.

Managing Security for Stored Procedures

Stored procedures are probably the most frequently used database objects for a database developer. As with other database objects, stored procedures ...