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: bhogak <bhogak_at_yahoo.com>
Date: Wed, 26 Dec 2001 19:49:10 GMT
Message-ID: <WQpW7.15532$Sa5.995256@rwcrnsc53>


Ganesh Raja wrote:

> "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message
> news:<a0bv5c$8tg3$2_at_as201.hinet.hr>...
> > 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.
>
> Internal : Used for database Creation.. No actual User and when
> connected uses the sys Schema. Deperecated from version 9i Onwards...
> Supported in 8i for Backward Comp.
>
> Sys : The Actual User Who Owns the Data Dictionary tables. He is THE
> man in the Oracle database. He is also the user who is entered into
> the pwd file when u create
> the same.
>
> System : The Administrative user who can do a lot of administrative
> Tasks. Mainly used for Administration.
>
> HTH
>
> Regards,
> Ganesh R

Thanks.

-- 
bhogak
Received on Wed Dec 26 2001 - 13:49:10 CST

Original text of this message

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