Re: Connect INTERNAL ??? / WAS(Re: Getting SYSDBA rights on Oracle 7.3.4 )

From: Luuk <luuk_at_doge.nl>
Date: Fri, 29 Jun 2001 21:38:05 +0200
Message-ID: <9hilhk$kkl$1@news.hccnet.nl>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schreef in bericht news:tjphe4oclo0n81_at_beta-news.demon.nl...
>
> "Luuk" <luuk_at_doge.nl> wrote in message news:9hhquf$1s0$1_at_news.hccnet.nl...
> >
> > "lv" <-luuk_at_doge.nl> schreef in bericht
 news:9hhj7b$qac$1_at_news.hccnet.nl...
> > > Hi,
> > >
> > > I did a fresh install on NT4(SP6) of Oracle 7.3.4
> > >
> > > When i type "CONNECT SYS AS SYSDBA;" at the SVRMGR prompt, Oracle
 replies
> > > with an error "ORA-01031 insufficient privieges"
> > > The documentation states that i should have those rights by default,
 so
 i'm
> > > puzzled
> > > Any help is welcome,
> > >
> > > Luuk
> > >
> > >
> > >
> > Search the internet, (deeper than before the first message) and came up
 with
> > the following:
> > I can connect as 'INTERNAL'
> > but i am alos able to connect from my workstation to the server, WITHOUT
> > PASSWORD!
> >
> > My question: is it possible to dissalow someone to connect as INTERNAL ?
> > What should i change to dissallow loggin in as INTERNAL for everyone
 except
> > 'Administrator'?
> >
> > Luuk
> >
> >
>
> init.ora's parameter remote_login_passwordfile should be set to NONE
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>

 The docs said:

||
||To Use Operating System Authentication
||
||1. Set up the user to be authenticated by the operating system.
||
||2. Make sure that the initialization parameter, REMOTE_LOGIN_PASSWORD, is

set to NONE, which is the ||default value for this parameter.

so i didnt check, but it is on SHARED, when i change this to NONE, will there be any other site effects?

Greetings and thanks,
Luuk Received on Fri Jun 29 2001 - 14:38:05 CDT