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 -> Must Oracle users identified externally log in as '/' ?

Must Oracle users identified externally log in as '/' ?

From: Michael Butler <mbutler_at_starsolutions.com.au>
Date: Wed, 27 Oct 1999 13:59:25 +0930
Message-ID: <%avR3.1254$1C1.4863@ozemail.com.au>


Hi all,

I am running a Centura CTD 1.1.2 application against Oracle. I want to change the users such that they are identified externally by the Operating System (NT) when users log on to the network. This requires the Oracle SQL statement:

CREATE USER OPS$MIKE IDENTIFIED EXTERNALLY; for the network user MIKE. Then when trying to connect to Oracle you must enter a forward slash, /, as userid (SqlUser) and no password entry is required. Problem is Centura seems to use a connect string of the form:

"databasename/user/password"

and having a userid of '/' produces the error:

00194 SQL MTT More than two slashes in connect

      Reason: Attempting to connect to a database and the specified database
       name, username, and password string contains more than two
       forward slashes. The forward slash separates the database name,
       username, and password, therefore a maximum of only two forward
       slashes are necessary.

      Remedy: Modify the connect string containing the database, username,
and
       password so it is of the form "databasename/username/password".

Does anyone know of a workaround ? Thanks in advance...

Mike Received on Tue Oct 26 1999 - 23:29:25 CDT

Original text of this message

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