Re: why administrator refuse to give permission on PLUSTRACE

On 2007-11-03 16:25, DA Morgan <damorgan_at_psoug.org> wrote:
> Peter J. Holzer wrote:
>> On 2007-11-03 13:19, DA Morgan <damorgan_at_psoug.org> wrote:
>>> Marc Blum wrote:
>>>> On Fri, 02 Nov 2007 12:35:53 -0700, DA Morgan <damorgan_at_psoug.org> wrote:
>>>>
>>>>> Was it the application running on a client? The developer is useless.
>>>> sorry??? you're kiddin'!?
>>>>
>>>> Dear DA,
>>>>
>>>> IMHO, with this answer you kicked yourself out of business.
>>> PL/SQL developers don't fix application code ...
>>
>> Who said anything about PL/SQL developers? "The developer" is the
>> developer of the application with the problem.
>
> So you are going to give DBA privs to the Java developer? Now you've
> really got me frightened.

I thought so :-).

>>> C or Java developers do.
>>
>> If the application is written in C or Java, then the developer will be a
>> C or Java developer. If his application accesses the database directly
>> he should still know enough about the database to diagnose problems. How
>> else could he develop the application in the first place?
>
> Listen to yourself for a second. A Java developer writes code that runs
> on an application server.

He also writes SQL queries which run on the database (If he doesn't, he doesn't belong in this thread). He may even be the one who designed the data model.

> The product is a JAR or EAR file perhaps.

What do glorified ZIP files have to do with this thread?

> This person's knowledge of wait events is precisely zero. Likely they
> can't even construct a decent WHERE clause.

If they can't do this they have no business writing software which sends SQL queries to an RDBMS. Let somebody else who does have some clue about databases design a middle tier which they can connect to. Or send them to training or fire them - but for heaven's sake don't let them write code which runs on your hallowed production database.

        hp

-- 
   _  | Peter J. Holzer    | It took a genius to create [TeX],
|_|_) | Sysadmin WSR       | and it takes a genius to maintain it.
| |   | hjp_at_hjp.at         | That's not engineering, that's art.
__/   | http://www.hjp.at/ |	-- David Kastrup in comp.text.tex