Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DO I GIVE PROGRAMMERS ORACLE DBA ACCOUNT?

Re: DO I GIVE PROGRAMMERS ORACLE DBA ACCOUNT?

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Mon, 24 Jul 2000 21:32:20 -0300
Message-Id: <10568.112820@fatcity.com>


On Mon, 24 Jul 2000, you wrote:
> Sending this again, Because I did not have a subject last time.
>
> I sure would appreciate some opinions on this. At my place of work we have
> two teams in our division. One team is the application programmers and the
> other team is UNIX system/Oracle DBAs. I have a new platform that just
> came in. I need to set up the Oracle database and Oracle Application Server
> on it. Here's the question. My application programmer wants the Oracle
> DBA account and the sys account. This platform is not a test platform.
> Yes they are developing on this platform and then it will go into
> production. My Oracle DBA's do not want to give out the accounts to the
> developers.
> Who do I please?

I would never give DBA to anyone besides a DBA (nor system. I'd never give sys out unless I was absolutely certain the person was competent).

On a related topic, I have no real problems giving DBA (or a close subset of privs) out on a test environment, provided the developers realize that:

A) they won't have the same privs on production
B) they may not have any privs on production, and 
C) They break it, they fix it. The database goes down due to
their actions, it's restored from cold backups - any changes they made for testing are lost. Any objects they drop, they create, yada yada.

Of course, this is only for initial testing. Any changes that will be introduced go through more rigorous testing on non-dba accounts.

Cheers,
GC

-- 
I love the way Microsoft follows standards.  In much the
same manner that fish follow migrating caribou.
Received on Mon Jul 24 2000 - 19:32:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US