| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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).
 |
 |