RE: DO I GIVE PROGRAMMERS ORACLE DBA ACCOUNT?

NEVER give them DBA role. They can buy DBA books from the bookstore and "practise" on your database! Developers are very dangerous species.

Here, they have to beg me even for the RESOURCE role! :P

Winnie :)

"Taylor, Shirley" <TaylorSI_at_mar.dfo-mpo.gc.ca> on 07/24/2000 01:09:40 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: RE: DO I GIVE PROGRAMMERS ORACLE DBA ACCOUNT?

At this site, we do not give application developers the dba role. But we have created a role which thru which we give them specific privileges. eg. Select on the dba views and execute on several of the dbms packages.

> -----Original Message-----
> From: Donna_M_Vail_at_sd.fisc.navy.mil

[SMTP:Donna_M_Vail_at_sd.fisc.navy.mil]
> Sent: Monday, July 24, 2000 3:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: DO I GIVE PROGRAMMERS ORACLE DBA ACCOUNT?
>
> 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: Taylor, Shirley
  INET: TaylorSI_at_mar.dfo-mpo.gc.ca

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).