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: Connect INTERNAL ??? / WAS(Re: Getting SYSDBA rights on Oracle 7.3.4 )

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 29 Jun 2001 20:17:44 +0200
Message-ID: <tjphe4oclo0n81@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 Received on Fri Jun 29 2001 - 13:17:44 CDT

Original text of this message

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