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: DA Morgan <>
Date: Fri, 02 Nov 2007 12:35:53 -0700
Message-ID: <>

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.

Great generalities. But lets pursue this. You are that developer. What privileges do you require? What are you going to do? Lets see specifics. I am really interested in hearing from any developer that thinks they can justify this.

 From my perspective ... the applicatoin came to a grinding halt. What is step #1? In my book it is determine what came to a halt. Was it the application running on a client? The developer use useless. Was it a network router or hub? The developer is useless. Was it a storage related issue? The developer is useless. Did the server crash at the operating system or instance level? The developer is useless. Anyone that is a developer want to demonstrate their skill in addressing this specific issue "production ist coming to a grinding halt" and tell me what they would do. Thanks.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Nov 02 2007 - 14:35:53 CDT

Original text of this message