Worse yet, if you want to use the ~Intelligent agent~ with a different password,
you have to place the username/password into $ORACLE_HOME/network/admin/snmp_rw.ora.
Of course that should only be read by Oracle, the DBA group and above.
----- Original Message -----
From: Rachel Carmichael <carmichr_at_hotmail.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Wednesday, August 09, 2000 10:24 PM
Subject: Re: Unfamiliar Schema Owners
> Welcome to the wonderful world of a Dynamo database.. I've been managing one
> for a year.
>
> Okay the schema owners you listed are Oracle supplied schemas, as follows:
>
> OUTLN -- used for storing outline plans
> CTXSYS -- Intermedia owner (used to be called Context, thus the CTX)
> AURORA$ORB$UNAUTHENTICATED -- JVM owner
> DBSNMP -- Intelligent Agent
>
> so.. if you are not using Intermedia, you can drop CTXSYS. If you are not
> using Oracle Names Server or OEM, you can drop DBSNMP.
>
> If you are wary of dropping the users, at least change the passwords and see
> if anything breaks.
>
> And check the privileges and roles that have been granted to these users --
> DBSNMP usually gets the DBA role. And the password is DBSNMP. Not exactly
> secure.
>
>
>
>
> >From: "Lucia DeMeester" <ldemeester_at_nm2.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Unfamiliar Schema Owners
> >Date: Wed, 09 Aug 2000 17:59:12 -0800
> >
> >I just took over support for an ATG Dynamo database. The system tablespace
> >is allocated with 200M and it is 85% full already. It has not gone live
> >yet.
> >
> >After checking the schema owners, I discovered the following schema owners'
> >default tablepsace is sytem tablespace. They are OUTLN, CTXSYS,
> >AURORA$ORB$UNAUTHENTICATED, DBSNMP. I tried to search the Concept manual
> >and was not able to find it.
> >
> >Any comment on why do we need these schemas?
> >
> >Thanks in advance.
> >
> >Lucia
> >
> >
> >--
> >Author: Lucia DeMeester
> > INET: ldemeester_at_nm2.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).
>
> ________________________________________________________________________
> 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
Received on Fri Aug 11 2000 - 14:33:11 CDT
