Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: why administrator refuse to give permission on PLUSTRACE

Re: why administrator refuse to give permission on PLUSTRACE

From: Marc Blum <>
Date: Sun, 04 Nov 2007 12:06:52 +0100
Message-ID: <>

On Sat, 03 Nov 2007 21:23:42 +0000, Niall Litchfield <> wrote:

>Marc Blum wrote:
>> On Fri, 26 Oct 2007 23:11:51 -0700, DA Morgan <> 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.

>Mind you for
>all of the folks that have setups where the developers know the business
>and the dbas don't I sure hope the support calls all go to the
>developers first - anything else would be a misroute.

Support calls don't go to the DBA nor to the developers. These guys are in the second or even third level support layer. Received on Sun Nov 04 2007 - 05:06:52 CST

Original text of this message