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

Hi,

if you have the identifier as OPS$ (the default) then you can create the user (eg ops$oracle) with a pssword.
this gives you the ability to either log on with os authentication (ie /) or with an oracle password.

This does not appear to be documented very well, and it only works when the init.ora parameter os_authent_prefix is set as ops$ (the default) and does not work with any other value.

HTH NeilC

Michael Butler wrote in message
>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 Wed Oct 27 1999 - 09:52:23 CDT