Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYS & SYSTEM?
Does this group have a FAQ for common questions? I think it's a great place to ask questions of others, but I agree that some questions are so basic that I am almost afraid to answer them. Kind of the old saying "A little knowledge is a dangerous thing".
-- Dave A "Howard J. Rogers" <howardjr_at_www.com> wrote in message news:39fbe8d6_at_news.iprimus.com.au...Received on Sun Oct 29 2000 - 08:45:54 CST
> 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.
>
>