Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SYS & SYSTEM?

Re: SYS & SYSTEM?

From: Dave A <dave_and_vanna_at_hotmail.com>
Date: Sun, 29 Oct 2000 08:45:54 -0600
Message-ID: <svodnei7pm4o19@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
> > ------------------------------------------------------------------------
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Sun Oct 29 2000 - 08:45:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US