Re: OS Authentication & SQL*Net

skelley_at_hsc.hac.com (KELLEY SCOTT A) wrote:

>In article <31E57D9C.46B1_at_dca.net>, Ed Jennings <jennings_at_dca.net> writes:
>>Stephen Turner wrote:
>>>
>>> The SQL*Net book implies that an Oracle user can be set up to
>>> use OS authentication from a local login, but require a password
>>> from a SQL*Net connection. It doesn't gice the details on how to set
>>> this up though.
>>>
>>> Any suggestions?
>>> Thanks,
>>> Steve TurnerI have this identical problem. Any help would be greatly appreciated.
>>--
>>~~~~~~~~~~~~~~~~~~~~~~~~~
>>jennings_at_dca.net
>
>
>You must have "REMOTE_OS_AUTHENT = TRUE" in your init.ora. I may have mispelled the parameter slightly.
>
>
>
>
> Thanks,
> Scott Kelley, Oracle Corp. (skelley_at_hsc.hac.com) "Oh! My eye!"
> (310) 364 7519
>
>

But doesn't that only work of the remote O/S has password protection?

I'm interested in this thread too because I've never been able to get it to work. The SQL*Net documentation is pretty spartan.

I've got the parameter set but still can't log in without an Oracle password except on the local machine.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!