I was just recently playing around with this and found a couple of tips to
fix my problem:
There is a registry setting called: OSAUTH_PREFIX_DOMAIN that is now
defaulted to TRUE for 8.1 databases. To get my machine to login without a
username/password I had to create an oracle user name like
"MYDOMAIN\USERABC". ( not sure if it matters but the notes also said to put
everything in uppercase). You can set this to false and then i believe the
domain name can be left off the oracle username.
There is an init.ora parameter = REMOTE_OS_AUTHENT that must be set to TRUE
( I do believe this causes some security risks so you may want to
investigate those issues to.)
There is also an init.ora parameter OS_AUTHENT_PREFIX that needs to be set.
I believe the default is now "" (no prefix required for the oracle user
account).
I used these keywords and was able to locate some helpful documents in
Metalink.
HTH, Jim
References Metalink: Note:102665.1
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wednesday, April 18, 2001 2:28 AM
>Hi!
>
>Oracle8.1.7 on WinNT.
>I created database user with external authentication with whom I'm logged
on
>that WinNT server.
>When I start exp there is error
> invalid username/password logon denied.
>What am I missing? It works just fine on UNIX!
>
>TIA,
>Sonja
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jim Walski
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
