Re: Difference between SYS and SYSTEM

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.

In simple terms (and thus not altogether accurate) -

• sys OWNS the database
• system MANAGES the database

Thus although administrators often mix and match between both, the "politically correct" option is intended for SYSTEM (or equivalent authority) to perform most/all day to day administrative options.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse