Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: is INTERNAL a role or a user?

Re: is INTERNAL a role or a user?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 3 May 2002 21:47:30 +0200
Message-ID: <ud5rgdibhenu2c@corp.supernews.com>


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...

> 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 ?
> >
> >
> >
> >
>
>
Received on Fri May 03 2002 - 14:47:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US