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: George Barbour <george.barbour_at_gecm.com>
Date: Mon, 30 Oct 2000 15:47:53 -0000
Message-ID: <39fd971a$1@pull.gecm.com>

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
> >



> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
>
Received on Mon Oct 30 2000 - 09:47:53 CST

Original text of this message

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