Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> has anyone had troubles with loggin as SYS with sql*plus 8.1.7.0 and not getting DBA rights?
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
Received on Thu Jan 17 2002 - 03:31:59 CST