question

siera_gld avatar image
siera_gld asked

Server Roles DBA's and Developers

I am trying to determine the best roles to assign to Developers without sysadmin. Developers need to Create db's (dbcreator, dbowner) Manage SQL Agent Jobs (Create/delete/schedule) Manage SSIS jobs in the msdb package store. Can someone lead me to a link to better describe ways to setup roles in the SQL Security context without having sysadmin privelages for developers?
sqlsecurityroles
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Please mark any helpful answers by clicking on the thumbs up next to them. The answer that best solved your problem should be indicated by clicking on the check box next to it.
0 Likes 0 ·

2 Answers

·
sqlaj 1 avatar image
sqlaj 1 answered
Depending on the version of SQL Server you are running you will have more options. Here is a link with server and database role information/explanation. http://sqlserverpedia.com/wiki/Built-In_Server_Roles_%26_Database_Roles This is one from msdn and on SQL 2012: http://msdn.microsoft.com/en-us/library/ms188659.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

tomgough79 avatar image
tomgough79 answered
The other approach you might want to consider is to create an AD group for your developers and set the specific securables at a server level for that group
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.