Re: Database assistant problem

From: Tom Brown <tom_at_eazyriders.com>
Date: Tue, 26 Mar 2002 18:56:49 GMT
Message-ID: <Rv3o8.3358$yk4.20952120@news-text.cableinet.net>

Thanks that worked a treat. I did at first encounter a public password problem but a quick search on Google sorted that.

many thanks again

Tom

"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message news:I9gm8.12044$9A5.562846823_at_newssvr21.news.prodigy.com...
> Tom,
>
> Try connecting in svrmgrl as internal and then: GRANT SYSDBA TO <USER>;
>
> Then the user should be able to connect AS SYSDBA.
>
> Hope that helps.
>
> Trifon Anguelov
> Senior Oracle DBA
>
> visit the latest Oracle DBA forums:
> http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
>
> --------------------------------------------------------------------------

--


> -------------

> "Tom Brown" <tom_at_eazyriders.com> wrote in message

> news:X77m8.4887$bm6.35259602_at_news-text.cableinet.net...

> > Hi,

> >

> > When i run the database assistant on 8.1.7 and NT and try and connect to

a


> > database as SYS/**PASSWORD** it fails with a invalid username and/or

> > password when i connect as SYSDBA BUT when i connect with sqlplus using

> the

> > same info it works fine... eg

> >

> > sqlplus SYS/**PASSWORD**@SID i can get in and have full access?

> >

> > does anyone know why this might be?

> >

> > thanks

> >

> > Tom

> >

> >

> >

>

>

Received on Tue Mar 26 2002 - 12:56:49 CST