One minor correction from a terminology perspective. INTERNAL was
deprecated in Oracle8 and is gone entirely in Oracle9. "Deprecated" is
Oracle-speak for "we're going to get rid of this soon".
--
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
"Ganesh Raja" <ganesh_at_gtfs-gulf.com> wrote in message
news:a8aed4.0112260212.6c6f0b26_at_posting.google.com...
> "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
Received on Wed Dec 26 2001 - 10:23:20 CST
