Notes on SQL

Random articles from a puzzled DBA

And how to assign Server-Level permissions to a database user. Background In a previous article I gave an example of assigning permissions to a user and making use of the EXECUTE AS instruction. This is a very useful way of assigning database permissions in a very granular way, where a user should not have the …

Continue reading