the problem with "it's just development" and allowing developers to do
anything in that environment is that they can and will and DO start
coding based on objects they have created -- and those objects may or
may not conform to good practices within a production environment.
Once the code is written and tested against garbage, it's almost
impossible to get them to change it to the way it should be done.
And, I have NEVER, in 12+ years as a DBA, found that a corrupted
database, even if caused by a developer, is not my responsibility to
fix, and fix fast and "how could you let this happen"
I am more than willing to allow my developers restricted access to the
database. I even let them create objects, within their own schemas. But
NOT within the copy of the production schema.
- ryan.gaffuri_at_cox.net wrote:
> its just development. i guess it depends on the nature of the
> developer. We dont let the software engineers have any privileges,
> but the database developers can do just about everything in
> development.
>
>
> >
> > From: "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk>
> > Date: 2004/02/24 Tue PM 04:47:34 EST
> > To: <oracle-l_at_freelists.org>
> > Subject: RE: RE: Frustration with Toad Debugger
> >
> > apologies for the double post - one should make it without all them
> fancy equalities.
> >
> > SQL> create spfile from pfile;
> > File created.
> > SQL> create user dev identified by dont_trust_em;
> > User created.
> > SQL> grant create session,alter system to dev;
> > Grant succeeded.
> > SQL> startup force;
> > ORACLE instance started.
> > Total System Global Area 122755896 bytes
> > Fixed Size 453432 bytes
> > Variable Size 88080384 bytes
> > Database Buffers 33554432 bytes
> > Redo Buffers 667648 bytes
> > Database mounted.
> > Database opened.
> > SQL> conn dev/dont_trust_em
> > Connected.
> > SQL> alter system set sql_trace=true scope=spfile;
> > System altered.
> > SQL> alter system set timed_statistics=false;
> > System altered.
> > SQL> alter system set db_cache_size=20m;
> > System altered.
> > SQL>
> >
> > need I go on...
> >
> > Niall
> >
> > -----Original Message-----
> > From: AC.GWIA.oracle-l_at_freelists.org
> [mailto:AC.GWIA.oracle-l_at_freelists.org]
> > Sent: Tue 24/02/2004 18:57
> > To: oracle-l_at_freelists.org; ryan.gaffuri_at_cox.net
> > Cc:
> > Subject: RE: RE: Frustration with Toad Debugger
> >
> >
> >
> > in development? that is silly. there is no reason why a developer
> shouldnt be
> > able to kill his own session.
> >
> > >
> > > From: "Koivu, Lisa" <Lisa.Koivu_at_Cendant-TRG.com>
> > > Date: 2004/02/24 Tue PM 01:50:03 EST
> > > To: <oracle-l_at_freelists.org>
> > > Subject: RE: RE: Frustration with Toad Debugger
> > >
> > > Are you kidding, I'd never give a developer alter system priv. I
>
> > > wrapped it in a package and made it schema-specific as to what
> sessions > they can kill.
> > >
> > >
> > > -----Original Message-----
> > > From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net]
> > > Sent: Tuesday, February 24, 2004 1:42 PM
> > > To: oracle-l_at_freelists.org
> > > Subject: Re: RE: Frustration with Toad Debugger
> > >
> > > is it really that bad for you to give developers the ability to
> kill
> > > sessions? if your afraid of general alter system privileges you
> can wrap > it in a package?
> > >
> > >
> > > >
> > > > From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
> > > > Date: 2004/02/24 Tue PM 01:23:01 EST
> > > > To: oracle-l_at_freelists.org
> > > > Subject: RE: Frustration with Toad Debugger
> > > >
> > > > Our Developers use 7.6.0.11
> > > >
> > > > - Kirti
> > > >
> > > > --- "Jesse, Rich" <Rich.Jesse_at_quadtechworld.com> wrote:
> > > > > What versions of TOAD are y'all on?
> > > > >
> > > > > Rich
> > > > >
> > > > > Rich Jesse System/Database
> Administrator
> > > > > rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
> > > > >
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Kirtikumar Deshpande
> [mailto:kirtikumar_deshpande_at_yahoo.com] > > > > Sent: Tuesday,
> February 24, 2004 12:09 PM
> > > > > > To: oracle-l_at_freelists.org
> > > > > > Subject: Re: Frustration with Toad Debugger
> > > > > >
> > > > > >
> > > > > > Lisa,
> > > > > > So, you are the only one..
> > > > > >
> > > > > > I get gazzillion requests from our Developers to kill their
>
> > > > > > hung TOAD sessions when they play with
> > > > > > this debugger thing. I doubt if this is a completely bug
> free
> > > > > > begugger!!
> > > > > >
> > > > > > - Kirti
> > > > > >
> > > > > >
> > > > > >
> > > > > > --- "Koivu, Lisa" <Lisa.Koivu_at_Cendant-TRG.com> wrote:
> > > > > > > Hi everyone,
> > > > > > >
> > > > > > > Has anyone ever gotten this to work??? I have tried
> several
> > > > > > different
> > > > > > > times to use it, and it gets stuck at the Set Parameters
> > > > > > dialog box.
> > > > > > >
> > > > > > > I tried to look at the yahoo group, but it's blocked from
> here. > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > > Lisa Koivu
> > > > >
> > > > >
> ----------------------------------------------------------------
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > >
> ----------------------------------------------------------------
> > > > > To unsubscribe send email to: oracle-l-request_at_freelists.org
>
> > > > > put 'unsubscribe' in the subject line.
> > > > > --
> > > > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > > > FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
> > > > >
> -----------------------------------------------------------------
> > > >
> > > >
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > Yahoo! Mail SpamGuard - Read only the mail you want.
> > > > http://antispam.yahoo.com/tools
> > > >
> ----------------------------------------------------------------
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > >
> ----------------------------------------------------------------
> > > > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > >
> -----------------------------------------------------------------
> > > >
> > >
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
> > > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
>
> > >
> > > "The sender believes that this E-Mail and any attachments were
> free of any
> > virus, worm, Trojan horse, and/or malicious code when sent. This
> message and
> > its attachments could have been infected during transmission. By
> reading the
> > message and opening any attachments, the recipient accepts full
> responsibility
> > for taking proactive and remedial action about viruses and other
> defects. The
> > sender's business entity is not liable for any loss or damage
> arising in any
> > way from this message or its attachments."
> > >
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
>
=== message truncated ===
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Feb 25 2004 - 07:15:14 CST
