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

Home -> Community -> Usenet -> c.d.o.server -> Re: has anyone had troubles with loggin as SYS with sql*plus 8.1.7.0 and not getting DBA rights?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 17 Jan 2002 18:50:20 +0100
Message-ID: <qk3e4us9gtovjji7l1gathu4mc9adivlvd@4ax.com>

On Thu, 17 Jan 2002 09:31:59 GMT, nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote:

>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

This 'feature' is, IIRC, not limited to NT, and not limited to 8.1.7

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 17 2002 - 11:50:20 CST