Re: Difference between SYS and SYSTEM

From: <billmil_at_my-deja.com>
Date: 2000/04/05
Message-ID: <8cg6m4$l8p$1@nnrp1.deja.com>#1/1

SYS owns the data dictionary. You use "SYS" when you issue a "CONNECT INTERNAL". SYSTEM "is used to manage the database", and occasionally holds packages and tables. (From the O'Reilly Oracle DBA book, p. 466)

You should never have to log on as sys and should never create tables in the SYS schema. Some scripts require you to log on as SYSTEM (the script to create the SQLPLUS Help, for example).

bill milbratz

In article <8cfuca$bbo$1_at_nnrp1.deja.com>, vasarpota_at_my-deja.com wrote:
> Can someone please tell me the difference between SYS and SYSTEM? I
> understand that both are users belonging to the DBA role. I also
> understand that they have different passwords. But what is the real
> difference besides the schema. Is SYS used by DBAs and SYSTEM by
> Oracle tools? SYSTEM user can't view the data dictionary (owned by SYS
> schema)? Why have two? Please Help
>
> Thanks in advance for any help
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 05 2000 - 00:00:00 CDT