Due to the large amount of spam comments that I received over the last weeks, I decided to disable anonymous comments.

[UPDATE 8/24/2010] : I added a companion post covering the theory behind this demo . There is an excellent article on this topic in Books Online: Extending Database Impersonation by Using Execute As . I just wrote a small demo to illustrate the techniques...

A while ago, I wrote a post showing how signatures can be used to allow users to perform operations without explicitly granting them the permissions required for that operation. In this post I'll present more details about the use of signatures. One...