Re: How do you feel about allowing non-DBA's on your database servers?
Date: Mon, 27 Jul 2009 13:07:12 -0500 (CDT)
> If you
> don't allow developers on the PROD system, how are they going to
> trouble-shoot problems which surface in the PROD system but not the TEST
Therein lies one of the most prevalent problems in business software development today, IMHO -- testing. Is it right to assume that a Production database will contain the necessary data scenarios that need to be tested?
This is a huge subject that can hardly be decided by a few over a mailing list. It's a complex issue with real dollars attached. Comprehensive testing on a change to a complex system like an ERP is not cheap. And perhaps in (many?) cases, not warranted. But the inverse of assuming that one can only properly test with Production data is missing the target.
Programmer, SA, DBA over the past 20+ years.