Re: authentication externally on WinNT

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 <ORACLE-L_at_fatcity.com> 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: sonja.sehovic_at_pbz.hr
>
>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: ListGuru_at_fatcity.com (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: jwalski3_at_classicplan.com

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: ListGuru_at_fatcity.com (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).