Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: is INTERNAL a role or a user?
No
It is a special user, which isn't checked against the dictionary, but against a separate password file. It started of as a mechanism to give you access to the database in nomounted or mounted state, so with the database down.
Internal has been deprecated though with 8.0 and has disappeared from 9i
Please us either O/S authentication
(connect / as sysdba)
or explicit username authentication
connect <user>/<password> as sysdba
Hth
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail address "Richard Armstrong" <richard.armstrong_at_juno.demon.co.uk> wrote in message news:1020422874.27511.0.nnrp-01.9e9809ca_at_news.demon.co.uk...Received on Fri May 03 2002 - 14:47:30 CDT
> Isn't it a sort of nickname for the SYS user?
>
> "Lanying & Manfred Chen-Fischer" <manfis_at_t-online.de> wrote in message
> news:aatg7c$prs$06$1_at_news.t-online.com...
> > Hello friends,
> >
> > how to explain a newbi the object INTERNAL
> >
> > svrmgrl> connect internal/oracle
> >
> > I can't imagine that internal is a user ?
> >
> >
> >
> >
>
>