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 -> automatic authentication in Oracle 8 sqlplus

automatic authentication in Oracle 8 sqlplus

From: Rod Bruce <rod_at_cpsg.com.au>
Date: 2000/07/20
Message-ID: <acvd5.144$7x5.5114@nsw.nnrp.telstra.net>#1/1

Hi,
Wonder if anybody can tell me why the following works ok V7 but not so ok in V8 ...

.
.

$ whoami
fred

$ sqlplus system/manager

    grant connect to ops$fred identified by fred;     exit;

$ sqlplus /
.
.

In V7 we get an automatic login as ops$fred but in V8 we get - ORA-01017: invalid username/password; logon denied

Anybody know why this would be so?

Thanks in anticipation.
Rod Received on Thu Jul 20 2000 - 00:00:00 CDT

Original text of this message

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