Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: catproc run as system

RE: catproc run as system

From: Deshpande, Kirti <Kirti.Deshpande_at_gtedc.gte.com>
Date: Thu, 25 May 2000 07:54:00 -0500
Message-Id: <10508.106660@fatcity.com>


I wonder why Oracle does not check for connected user's name/id in some of these important scripts...

> -----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).
Received on Thu May 25 2000 - 07:54:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US