Tag Archives: Security

What are the impersonation rights for my database users?

From time to time I get thrown the odd request to provide various bits of information from the SQL Server environment and most recently I was asked about a group of databases that required migrating to another instance. For some … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , , , , , ,

Generating GRANT statements because its quicker

Just a very quick post here, but sometimes when you wish to grant execute right for multiple stored procedures to a particular database user it is easier to simply run the following script in the respective database in order to … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , ,