Re: Difference between sys, system, and internal

From: Yannick Kermabon <y.kermabon_at_tegelog.fr>
Date: Mon, 18 Sep 2000 08:54:11 GMT
Message-ID: <39c5d56e.345298222@news.fr.uu.net>

On 18 Sep 2000 02:28:23 GMT, dalex_at_owt.com (Dalex) wrote:

Hi Dalex

I'm not a "master" DBA, but with my experience I think that the following is right :

sys is the owner of system tables and views. You are not supposed to do anything whitin this schema.
system is the default admin for the database. You can use it to manage users, security and database organisation.
internal is not a database user. It can be used to start, stop and maintain the database. You can also use sys or system to do that (connect as SYSOPER or SYSDBA) or any other user if you allow it.

HTH
Yannick

>* What are the differences between the sys, system, and internal accounts?
>
>* Under what circumstances would you use one versus another?
>
>
>Dalex
>dalex_at_owt.com
>
Received on Mon Sep 18 2000 - 03:54:11 CDT