Gavin Draper's Blog

Father, Developer, Tech Geek, Extreme Sports Fanatic

@gavdraper | +gavdraper | github | StackOverflow Careers
 

SQL Server Development Permissions

After setting up a new SQL Server instance for development I found the following permissions were needed extra permissions were needed to enable key development features… (Note these were for a development instance and should not be needed on a production database)

Permission To View Query Plans

This needs to be granted for each database….

GRANT SHOWPLAN TO [myDomain\myUser]

Permission To View Server Activity Monitor

USE master  
GO  
GRANT VIEW SERVER STATE TO [myDomain\myUser]

Permission To View Jobs/History

USE mdsb  
GO  
EXECUTE 'sp_addrolemember 'SQLAgentReaderRole', [myDomain\myUser] 

If you need to be able to start/stop jobs then swap SQLAgentReaderRole for SQLAgentOperatorRole.

Are there any other permissions you need for your day to day development work? Leave a comment and I'll add them here.


 
comments powered by Disqus