RE: OUTLN Mystery

I haven't tried that -- since it comes with the DBA role, you'd have to revoke it from the DBA role I would think.... and that has more repercussions than I want to deal with :)

>From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: OUTLN Mystery
>Date: Fri, 30 Jun 2000 07:44:42 -0800
>
>
> Instead of changing the passwords can you just revoke connect from outln?
>
> Rachel Carmichael <carmichr_at_HOTMAIL.COM> wrote:
>As a matter of course I change the passwords on the following:
>
>OUTLN
>CTXSYS
>DBSNMP
>SYS
>SYSTEM
>
>the only one that has implications that I know of is changing DBSNMP... if
>you use Intelligent Agents you have to set up a special password file on
>disk with the new password... see Kevin Loney's website
>(www.kevinloney.com)
>for the presentation he did on security -- he has the specifics on what to
>change in there.
>
>Rachel
>
>
> >From: "Gait, Christopher"
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L
> >Subject: RE: OUTLN Mystery
> >Date: Thu, 29 Jun 2000 22:07:17 -0800
> >
> >I definitely suggest changing it. We did and I haven't seen any shrapnel
> >fly
> >because of the change (on 8.1.5, not 8.1.6, however).
> >
> >I also have never heard of a reason to log in as OUTLN. It's just another
> >administrative schema Oracle uses for a particular purpose; in this case
> >storing execution plans for queries.
> >
> >-----Original Message-----
> >Sent: Thursday, June 29, 2000 1:32 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >So, I'm building an 8.1.6 database and find this OUTLN user/schema there.
> >From the docs it seems to have to do with fixing the explain plans for
> >specific queries. I presume I should leave it there. If so, I would think
> >I ought to change the password so everybody in the world can't login to
>my
> >database, just like with SYS, SYSTEM, and DBSNMP. Any implication of
> >changing the password? Who would need it?
> >--
> >Author: Smith, Andy
> > INET: andy.smith_at_gwl.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: Gait, Christopher
> > INET: cgait_at_condor.nrl.navy.mil
> >
> >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).
>
>
>---------------------------------
>Do You Yahoo!?
>Get Yahoo! Mail - Free email you can access from anywhere!