Re: Difference between sys, system, and internal

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Mon, 18 Sep 2000 17:45:14 GMT
Message-ID: <8q5kb2$upc$1@nnrp1.deja.com>

internal is the same as sys as sysdba. Oracle claims in DBA doc that use of internal is obsolete and will be discontinued in future releases. You can also use connect / as sysdba in most environments, it also connects you as Oracle user sys.

In article <39c5d56e.345298222_at_news.fr.uu.net>, y.kermabon_at_tegelog.fr (Yannick Kermabon) wrote:
> 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
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 12:45:14 CDT