Re: SYS & SYSTEM?

What's worse, I posted about this exact same question less than a week ago, at inordinate length. I don't mind doing it every so often, but once a week is too much!

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

<sybrandb_at_my-deja.com> wrote in message news:8tgnrl$4uh$1_at_nnrp1.deja.com...


> In article <8tgksm$itv2_at_imsp212.netvigator.com>,

>   "Eric" <ericchan1119_at_yahoo.com> wrote:

> > Hi all,

> > There are two default user (SYS and SYSTEM) are created when I

 created a new


> > database. What's their different?

> > Eric

> >

> >

>

> Sorry to say so, but this is a typical RTFM question. You can't get

> into Oracle without reading manuals, and usually you will be happily

> ignored in the Oracle newsgroups.

> SYS is the owner of the datadictionary. You should never ever create

> objects under SYS. System is a privileged account which can be used as

> DBA account (note: *can* not *should*) and which you also better don't

> touch and create objects under: it usually contains Oracle provided

> repositories for network management, advanced queuing and so on.

>

> Hth,

>

>

>

>

> --

> Sybrand Bakker, Oracle DBA

>

> All standard disclaimers apply

> ------------------------------------------------------------------------

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.