Re: Differences % INTERNAL and SYS

The fundamental difference is that SYS is a real account, and INTERNAL isn't an account at all (try doing a select username from dba_users and seeing whether somebody called 'INTERNAL' is ever listed).

INTERNAL is simply a key word that means 'log me on as a privileged user' (ie, one who is able to perform the 5 privileged actions of startup, shutdown, backup, recover or create database). If you do a select user from dual after connecting internal, you'll actually find yourself logged on as SYS -but as SYS with the privileges to do the privileged actions, instead of the more normal (though still very powerful) SYS user.

INTERNAL was deprecated in 8i, and has totally vanished in 9i. In its stead is another keyword meaning the same thing -or, rather, two key words: "AS SYSDBA". Hence "connect sys as sysdba" is exactly the same functionally as "connect internal". Since internal disappears in 9i, get out of the habit of using that keyword now, before investing time and effort in developing administration scripts that will break the second you upgrade.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Anonymous" <mail_for_deja_at_yahoo.com> wrote in message
news:8ee5d7c9.0111222022.3421957d_at_posting.google.com...


> Hi all,

>

>     What are the differences between INTERNAL and SYS account? Which

> database operations can (and can't) be done by INTERNAL and SYS?

>

> THanks,

> David