Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Should developers have permissions to SQL Server production queue?

Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH EXECUTEAS.

Some of our developers feel they should have access to the production jobs queue. If we grant this permission it's all or none. I can see their point about being able to manage the jobs. I have remained constant with my answer, "no." I know I am going to eventually modify this position. I also understand my question is more policy than technical. An objective opinion may be what the doctor ordered. Can you give me some advice?
SQL Server 2005 did introduce more granular permissions but not quite at the level you may have wished for in this case. If their needs are simple, have you considered giving them access to a proc, executed WITH EXECUTEAS that can do the job management for them?
This was last published in December 2007

Dig Deeper on SQL Server Security

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close