Re: Should developers have DBA role?
Date: 15 Jul 2003 12:29:39 -0700
Message-ID: <6669c584.0307151129.34eb5446_at_posting.google.com>
Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0307140538.6dba1f7c_at_posting.google.com>...
> Our location does not allow developers any create object privileges.
> All requests for objects are submitted to the DBA even for test
> systems.
That just isn't possible for us, resource-wise. 20+ developers, dozens of production systems, one dba. What is your developer/dba ratio?
If the developers want to compare schemas they can diff the
> source code and table describes.
We tried that, but the diff output is not very helpful. You'll get pages and pages of things that are "different" only because the schema name is different, and that one column that has a different size just doesn't stand out at all. Do you have any suggested scripts for diffing, that can be run by a non-dba? We normally want to diff two schemas with different names on the same instance, or two schemas with different names on different instances.
The DBA has charge of the production
> source. The developers check the code out, modify it, and request the
> DBA to apply the code to production.
>
What do you use for checkin/out?
It certainly does.
Larry Received on Tue Jul 15 2003 - 21:29:39 CEST