Re: has anyone had troubles with loggin as SYS with sql*plus 8.1.7.0 and not getting DBA rights?

nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote in message news:<3c469900.3034382_at_news-vip.optusnet.com.au>...
> NT4S, Oracle 8.1.7.0
>
> as the title says, if in sql*plus I use:
>
> prompt> connect sys/<password>@<dbalias> as SYSDBA<CR>
> prompt>
>
> I get DBA access rights.
>
> if I use:
>
> prompt> connect sys@<dbalias> as SYSDBA<CR>
> Enter Password: <password>
> prompt>
>
> then I don't get DBA rights.
>
>
> Any ideas wot's ticking or am I missing something obvious?
>
> TIA
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam

Hi Nuno,

Nice catch. This is a bug (I couldnt find the exact bug number on Metalink). I tried this on 8.1.7 on Windows, Solaris and Linux, and sure enough, if you enter the password on the password prompt, you dont get SYSDBA privs. But it works fine on 9.0.1 (Solaris and Linux), meaning I get SYSDBA privs any of the two ways I connect. So I guess they fixed it.

Murali
http://www.dbaquest.com/ Received on Thu Jan 17 2002 - 17:11:00 CST