Re: SYS versus SYSTEM

From: Tanel Põder <tanel_at_goatrancedotcom>
Date: Mon, 15 Nov 1999 17:58:14 +0200
Message-ID: <38302b18@news.infonet.ee>

> anyone can explain me when and how to use SYS user and when and how
use
> SYSTEM user ???

data dictionary views, dbms_ , standard packages are installed in sys schema,
system user is just an user with dba role. when you do connect internal you actually use the sys schema. sys user has by default the sysoper & osoper role too.
(at least 805 on hpux has)

do not store any objects of your own under sys.

tanel. Received on Mon Nov 15 1999 - 09:58:14 CST