RE: DO I GIVE PROGRAMMERS ORACLE DBA ACCOUNT?

Donna,

        Did you get your answer yet? I also worked for DOD (Defense Finance & Acctg Service) for 15 years and know that you are probably trying to please several management-types. Stick to your guns and get official sign off on anything that goes against your best judgement. If you have the space and time, and as long as the developers will agree (again, in writing) to "complete DBA" responsibility and that you are not their DBA teacher, clone a database from production or secured development and let them have at it. Once they start wrecking stuff (which is inevitable if they don't have proper skills), your point will be proven.

        I was in a very similar situation with me being one of two local DBAs (Denver) and four other remote DBAs (Indianapolis), working with contractor developers who wanted DBA access. It was a nightmare, but we kept our stand, and in the end, things worked out fine. Good luck to you, you are in a spot!

Tamara Swilley
Technical Consultant
AGENCY.COM
P.O. Box 3600
37347 US Hwy 6
Avon, Colorado 81620
V (970)845-2173
F (970)845-2150
E tswilley_at_agency.com

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of James Howerton
Sent: Monday, July 24, 2000 4:55 PM
To: Multiple recipients of list ORACLE-L Subject: Re: DO I GIVE PROGRAMMERS ORACLE DBA ACCOUNT?

"NO"

Happily take care of any sys or DBA things they need done. Also I use to work for the USAF & DISSA, I think the security GESTAPO types would have a problem with granting these privs to a non BDA/SA.

...JIM... Jim Howerton
Senior Oracle DBA
University of Alabama at Birmingham
Health System Information Services

e: jhowerton_at_uabmc.edu
v: 205-934-9111
f: 205-934-0632

>>> Donna_M_Vail_at_sd.fisc.navy.mil 7/24/00 1:57:45 PM >>>
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?

--
Author:
  INET: Donna_M_Vail_at_sd.fisc.navy.mil

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may