SQL Server Security

Giving Permissions through Stored Procedures

Understanding ownership chaining, particularly cross database ownership chaining can be tricky, particularly when techniques such as Dynamic SQL can break the ownership chain. This is a great article by Erland Sommarskog SQL Server MVP, that looks at ownership chaining and how to get around the issues that arise when using Dynamic SQL, through the use of signed stored procedures.