Dear Kirti, each of these scripts can be run by users with special
privileges ONLY...... try running catproc as scott.....
----- Original Message -----
From: Deshpande, Kirti <Kirti.Deshpande_at_gtedc.gte.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Thursday, May 25, 2000 7:47 PM
Subject: RE: catproc run as system
> I wonder why Oracle does not check for connected user's name/id in some of
> these important scripts...
>
> - Kirti
>
> > -----Original Message-----
> > From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> > Sent: Wednesday, May 24, 2000 8:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: catproc run as system
> >
> > I did that once... and the only way to fix it was to recreate the
> > database.
> >
> > sorry
> >
> > Rachel
> >
> >
> > >From: "S. Anthony Sequeira" <Sequeira_at_lineone.net>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: catproc run as system
> > >Date: Wed, 24 May 2000 14:04:07 -0800
> > >
> > >Hi,
> > >
> > > One of our trainee DBAs has managed to run catproc as system!
> > >Fortunately it is not a mission critical instance, though a production
> > >one. Surprisingly it is still running!
> > >
> > > Is there any easy way to 'uninstall' catproc from the system
schema,
> > >without going the exp/recreate/imp route?
> > >
> > > Regards.
> > >
> > >Tony
> > >--
> > >S. A. Sequeira
> > >
> > >One of these days I will
> > >cut you into little pieces
> > >
> > >Opinions expressed herein are my own and do
> > >not necessarily represent those of my employer
> > >
> > >--
> > >Author: S. Anthony Sequeira
> > > INET: Sequeira_at_lineone.net
> > >
> > >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).
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.com
> >
> > 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: Deshpande, Kirti
> INET: Kirti.Deshpande_at_gtedc.gte.com
>
> 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
Received on Thu May 25 2000 - 10:09:34 CDT
