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: INTERNAL, SYS, SYSTEM system users

Re: INTERNAL, SYS, SYSTEM system users

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Wed, 26 Dec 2001 14:14:20 -0800
Message-ID: <nXrW7.67$GN5.3527@inet-nntp1.oracle.com>


Not quite all the data dictionary tables are owned by SYS. Some are owned by SYSTEM (some of the AQ and replication tables come to mind). I think (though I haven't seen this confirmed anywhere) that this is because SYS tables are not exported by a full export but SYSTEM tables are.

--
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Currently writing the "Oracle9i New Features for Administrators Exam Cram"

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

"Matthew D. Bennett" <mbennett_at_utah-inter.net> wrote in message
news:3C2A459A.E4616F46_at_utah-inter.net...

> Stjepan,
>
> The difference between SYS and SYSTEM is important. SYS is the owner of
> all the data-dictionary tables and is like the super-super-user. SYSTEM
> is just the default database administrator account. You should never do
> anything in the SYS account unless it is resetting the password for the
> SYSTEM account (that is the only legitimate reason I have ever seen to
> use it).
>
> As for INTERNAL, that is mostly used for starting and stopping the
database.
>
> Matt.
>
>
>
> Stjepan Brbot wrote:
> >
> > INTERNAL, SYS and SYSTEM: for me the meaning and difference among these
> > three system users is a bit foggy and I will appreciate any efforts in
> > explanation or link to site where's that birefly explained.
> >
> > --
> >
> > Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
Received on Wed Dec 26 2001 - 16:14:20 CST

Original text of this message

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