Anonymous comments are now disabled

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

0

SQL Server 2005: Demo for enabling database impersonation for cross database access

[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 described in that article. It can be used as a companion to that article, if…

0

SQL Server 2005: An example for how to use counter signatures

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 important thing to keep in mind when working with signatures is that, normally, they will only have…

0