Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYS & SYSTEM?
A little knowledge is not the problem, it's the great swage of ignorance
that accompanies it that causes the problems.
G. Barbour.
"Dave A" <dave_and_vanna_at_hotmail.com> wrote in message
news:svodnei7pm4o19_at_corp.supernews.com...
> 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...
> > 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
> >