Re: Difference Between SYS and SYSTEM

From: Mark <cos_at_lambic.co.uk>
Date: 2000/09/20
Message-ID: <39C8F4CF.5740C03B@lambic.co.uk>#1/1

sdc wrote:
> What is the difference between these two user accounts? They are both
> automatically created, they both have the DBA role and they both own system
> tables and views. Why are there two accounts?

SYS is the owner of (nearly) all internal tables and packages.

SYSTEM has mainly synonyms and views based on the tables owned by SYS

I think the way Oracle explains it is 'SYS is the database owner, SYSTEM is the database maintainer' Received on Wed Sep 20 2000 - 00:00:00 CDT