Re: How do you feel about allowing non-DBA's on your database servers?

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
  • 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
> system?

[snip]

> Mike

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.

My $.02,
Rich
Programmer, SA, DBA over the past 20+ years.

--
//www.freelists.org/webpage/oracle-l


Other related posts: