Re: Sys And Internal

They're about as similar as two completely dissimilar peas in a pod.

SYS is a user. INTERNAL is a keyword that indicates the desire to connect to the database as a privileged user (ie, one who is capable of performing the privileged actions... backup, recover, startup, shutdown and create).

It happens that fundamentally, and under the hood, the only privileged user happens to be SYS, so when you connect "internal", you end up connecting as SYS with those privileges. Hence the (frequent) confusion between SYS the User and INTERNAL the keyword... the latter leads inevitably to the former. But not the other way around.

Incidentally, unlearn all of the above as quickly as possible: INTERNAL doesn't even exist as a keyword in 9i. One uses the "AS SYSDBA" keywords instead to achieve the same result. Strangely, people tend not to confuse SYS the User with AS SYSDBA the keywords in quite the same way as they did with INTERNAL -which is probably why Oracle adopted it.

Regards
HJR "Beginner" <oracle_at_epicentre.fr> wrote in message news:aea3sr$1ht$1_at_wanadoo.fr...
> Hi
> I'm writing a small documentation
>
> I want explain differences in a short description between SYS and INTERNAL
!
>
> Thanks
> André
>
>
Received on Sat Jun 15 2002 - 20:46:34 CDT