Re: Oracle 10 default users

The only users absoluetely necessary for the database to function are SYS and SYSTEM. Everything else is "optional" , but depending on the features you want to use (i.e. SYSMAN for the DB Console, ORDSYS/ORDPLUGINS for Intermedia (Multimedia in 11), CTXSYS for Oracle Text, etc etc).

Mind you, I'm not saying you can drop them all if they're there in your database, but you can safely lock them (or set an impossible password).

Stefan

On Fri, Mar 7, 2008 at 10:48 AM, John Dunn <JDunn_at_sefas.com> wrote:

> Whe Oracle 10 is installed there are a lot of users/schema created.
>
> Are there any it is safe to drop?...such as SCOTT...any others?
>
>
>
> John Dunn
>
> Product Consultant
>
> Sefas Innovation Limited
>
> Direct Dial + 44 (0) 117 373 6122
>
> *www.sefas.com*
>
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel:
> +44 (0) 117 373 6114 Fax: +44 (0) 117 373 6115
>
> *Sefas Innovation Limited. *Registered No: 3769761 England. Registered
> Office: One New Street, Wells, Somerset, BA5 2LA, United Kingdom. VAT
> Registration No: GB 741 5377 32
>
> Unless stated to be non-confidential, this email and any attachments are
> private and confidential and are for the addressee only. Sefas monitors
> e-mails to ensure its systems operate effectively and to minimize the risk
> of viruses. Whilst Sefas has taken reasonable steps to scan this email, it
> does not accept liability for any virus that may be contained in it.
>
> Internet communications are not 100% secure and as such Sefas is not
> responsible for their abuse by 3rd parties, nor for any alteration or
> corruption in transmission.
>
>
>

-- 
=========================

Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

--
http://www.freelists.org/webpage/oracle-l