The Multifunctioning DBA

Apr 30 2011   10:00AM GMT

Devs vs the DBA



Posted by: Colin Smith
Tags:

I am not a developer and I do not want to be and I know that developers have a job to get done but…..

Why is it that developers want to have elevated privileges in production??

That one I think I can answer at least partly.. From my experience it is because they want to test code in production. To that I ask WHY??? I have provided you a DEV, and Test server as well as QA. I do not get it… I know that I want to have the fewest priveledges required to do my job. Now as a DBA that means I get sysadmin role on all my SQL Servers but I do not need a Domain Admin account. I used to have one when I was a Systems Administrator but when I became a DBA I no longer require it. I do not want to have the ability to break something in production when I should be testing in DEV or TEST.

I recently had to do a restore of a prod database because a dev was running test code and blew up some data. I know that it is my fault for not taking away that level of access for them but that is something that I am working on and I just have not won that battle yet. I am getting close and now again this is more ammo for me.

Anyway….

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: