Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Must Oracle users identified externally log in as '/' ?
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