SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Permission to Create/Modify Stored Procedure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

djj55
Constraint Violating Yak Guru

USA
310 Posts

Posted - 12/19/2013 :  15:50:29  Show Profile  Reply with Quote
I am going to be out and would like to give the lead developer permission to create and modify stored procedures on the production server. In the past I just gave him sysadmin rites but would like a better way to grant premission for stored procedures only.

Note he has never given me cause to question what he has done with the sysadmin permission.

Thanks

djj

tkizer
Almighty SQL Goddess

USA
36636 Posts

Posted - 12/19/2013 :  16:13:31  Show Profile  Visit tkizer's Homepage  Reply with Quote
I certainly wouldn't allow this for a developer in production, but you could give out db_owner instead. I only give out that permission in non-prod. Devs get db_datareader ONLY in prod. DBAs take care of running scripts in prod.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

djj55
Constraint Violating Yak Guru

USA
310 Posts

Posted - 12/20/2013 :  08:30:21  Show Profile  Reply with Quote
Thanks! That did the trick. Since I am the only DBA (also know as 'Jack of many trades'), I need a backup when I am gone. All our code is in-house and updates are many, so someone needs permission to push the updates while I am gone. It does not help that some of the clients change how they want or send data frequently.
I now have a script to give and a script to drop permissions for him.

djj
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1644 Posts

Posted - 12/20/2013 :  18:35:39  Show Profile  Reply with Quote
One additional idea to consider in having a separate account that the "backup DBA" could use when they needed to act in the DBA function. In their usual developer's login, they would have restricted rights. If they needed to act as the DBA, they could login on this separate account, handle the emergency de jour and log back in under their developer's account.

=================================================
No, no, you're not thinking, you're just being logical. -Niels Bohr
Go to Top of Page

djj55
Constraint Violating Yak Guru

USA
310 Posts

Posted - 12/26/2013 :  07:02:22  Show Profile  Reply with Quote
Thanks Bustaz Kool, I will keep that in mind.

djj
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 12/27/2013 :  04:49:31  Show Profile  Reply with Quote
Thanks to all. I was about to post the similar kind of issue. But i got through that.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

Edited by - sgondesi on 12/27/2013 04:50:55
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000