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
> > ----------------------------------------------------------------
> > 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
> -----------------------------------------------------------------
>
>
>
>
> **********************************************************************
> This email contains information intended for
> the addressee only. It may be confidential
> and may be the subject of legal and/or
> professional privilege. Any dissemination,
> distribution, copyright or use of this
> communication without prior permission of
> the sender is strictly prohibited.
> **********************************************************************
>
> ----------------------------------------------------------------
> 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
-----------------------------------------------------------------
Received on Wed Feb 25 2004 - 06:44:43 CST
