Re: What is the different b/w INTERNAL and SYS

There is precisely zero difference between Internal and SYS.

Try doing a 'connect internal', followed by a 'select user from dual'. Guess which User you will actually have been logged on as.

However, bear in mind that SYS can log on in two different guises -SYS as SYSDBA and SYS fullstop. SYS fullstop is functionally equivalent to SYSTEM -powerful, DBA role possessor, etc etc. Only when SYS adopts the AS SYSDBA guise can it actually startup and shutdown Oracle Instances.

In that respect, Internal is just a rather shorter way of typing 'SYS as SYSDBA'. There's one other difference: SYS is still a valid User in 9i. Internal isn't.

Regards
HJR "John F. Keaveney" <johnkeaveney_at_targusinfo.com> wrote in message news:q7np6.113332$GV2.24862709_at_typhoon.san.rr.com...
> I'm not sure what all the differences are but I do know that internal can
> connect to an idle/shutdown instance using svrmgrl while sys can't.
>
> "Tim Lee" <timothy.yw.lee_at_philips.com> wrote in message
> news:9848l9$6s43_at_imsp212.netvigator.com...
> > Dear all:
> >
> > I have an Oracle Server running on NT.
> > Could someone tell me what is the different between the user account
> > INTERNAL and SYS pls.
> > Thanks!
> >
> >
>
>
Received on Wed Mar 07 2001 - 03:41:41 CST