Re: why administrator refuse to give permission on PLUSTRACE

On Sun, 04 Nov 2007 12:06:02 -0800, DA Morgan <damorgan_at_psoug.org> wrote:

>Marc Blum wrote:
>> On Sat, 03 Nov 2007 21:23:42 +0000, Niall Litchfield
>> <niall.litchfield_at_dial.pipex.com> wrote:
>>
>>> Marc Blum wrote:
>>>> On Fri, 26 Oct 2007 23:11:51 -0700, DA Morgan <damorgan_at_psoug.org> wrote:
>>>>
>>>>> Here I agree and I will go one step further. No developer should ever
>>>>> have access to a production database except as an end-user utilizing the
>>>>> application. I've yet to see a legitimate reason for any developer to
>>>>> have production access privs.
>>>> Maybe because there's some urgent issue to be solved, maybe production ist
>>>> coming to a grinding halt and there's a need for someone who knows the
>>>> requirements and the implementation and the technology to get rid of the issue
>>>> NOW! Production DBAs fail in the first and second point.
>>> If they do then at the very least the change control process if not the
>>> entire development process has failed. Surely the scenario above can
>>> only happen where the developers know what they are doing, why they are
>>> doing it and what they are doing it with - but unaccountably fail to
>>> tell anyone any of this? Equally a DBA that lets code to production with
>>> no idea of purpose, scope or impact isn't worth the name.
>>
>> hu? Do you live in the world of itzi-bitzi-mini-apps?
>>
>> In a production system, where the DBA is responsible for up & running of 100+
>> instances, and then a new system involving 20+ man*years of coding goes live,
>> then the DBA won't be the guy who knows the business rules implemented by this
>> big new app. Hopefully he has been involved in the steps of capacity planning
>> but it is completely out of focus to incorporate him in the whole
>> requierement/system design/app development/testing etc cycle.
>
>You are making an assumption not supported by real-world experience.
>
>It may be true that in your experience DBAs are not competent. But I can
>assure you that the DBAs at amazon.com know what is going on and nothing
>goes into production that they don't understand: Nothing.
>

Sorry, but you are turning things upside down. You are talking 'bout the exception. As others stated too, the average company, the average DBA is not the one caring for AMAZONs databases.

So, what ist the "real world"? The smart top-notch DBA at AMAZON or the average guy at tradeyourcar.com?

see, Danny, you're floored! Received on Mon Nov 05 2007 - 00:26:31 CST