Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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?

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

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 17 Jan 2002 09:31:59 GMT
Message-ID: <3c469900.3034382@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 Received on Thu Jan 17 2002 - 03:31:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US