Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
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?
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