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@xxxxxxxxxxxxxxxxxxxxxxx> > Date: 2004/02/24 Tue PM 04:47:34 EST > To: <oracle-l@xxxxxxxxxxxxx> > 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@xxxxxxxxxxxxx [mailto:AC.GWIA.oracle-l@xxxxxxxxxxxxx] > Sent: Tue 24/02/2004 18:57 > To: oracle-l@xxxxxxxxxxxxx; ryan.gaffuri@xxxxxxx > 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@xxxxxxxxxxxxxxx> > > Date: 2004/02/24 Tue PM 01:50:03 EST > > To: <oracle-l@xxxxxxxxxxxxx> > > 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@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx] > > Sent: Tuesday, February 24, 2004 1:42 PM > > To: oracle-l@xxxxxxxxxxxxx > > 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@xxxxxxxxx> > > > Date: 2004/02/24 Tue PM 01:23:01 EST > > > To: oracle-l@xxxxxxxxxxxxx > > > Subject: RE: Frustration with Toad Debugger > > > > > > Our Developers use 7.6.0.11 > > > > > > - Kirti > > > > > > --- "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx> wrote: > > > > What versions of TOAD are y'all on? > > > > > > > > Rich > > > > > > > > Rich Jesse System/Database Administrator > > > > rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA > > > > > > > > > > > > > -----Original Message----- > > > > > From: Kirtikumar Deshpande [mailto:kirtikumar_deshpande@xxxxxxxxx] > > > > > > > > > Sent: Tuesday, February 24, 2004 12:09 PM > > > > > To: oracle-l@xxxxxxxxxxxxx > > > > > 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx > > > > put 'unsubscribe' in the subject line. > > > > -- > > > > Archives are at //www.freelists.org/archives/oracle-l/ > > > > FAQ is at //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@xxxxxxxxxxxxx > > > put 'unsubscribe' in the subject line. > > > -- > > > Archives are at //www.freelists.org/archives/oracle-l/ > > > FAQ is at //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@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //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@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------