Re: Authentication Problem

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Thu, 31 Jan 2008 08:49:24 +0100
Message-ID: <486b2b610801302349k6f6652c3u569453884c1e283e@mail.gmail.com>


As far as I remember on windows the username has to be "OPS$<Client Machine Name>\<Username>".

To be sure, as Jack suggested, check v$session to get the exact form of your username.

Stefan

On Jan 31, 2008 2:18 AM, Khan, Muhammad S <Muhammad.Khan_at_ca.com> wrote:

> Hi Gurus.
>
>
>
>
>
> Its hard to believe what I'm stuck at here right now! I'm testing the OS
> authentication in my test environment with Oracle 9i database on Unix while
> client running on Windows. I set the following parameters in the init file
> for this:
>
>
>
> os_authent_prefix OPS$
>
> remote_os_authent TRUE
>
> remote_login_passwordfile NONE
>
>
>
> I created the user "OPS$<domainname>\<username>" and granted the necessary
> privileges required. This username is the same as my windows client user.
> Now when I'm trying to connect from the client through sqlplus, it prompts
> me for password and doesn't accept null password.
>
>
>
> I made different changes in the values for os_authent_prefix and set to ""
> or remote_os_authent to false but no good.
>
>
>
> What am I missing here? Is there any catch? Please help as I need to
> present the output very soon.
>
>
>
> Thanks,
>
> Khan.
>
>
>

-- 
=========================

Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 31 2008 - 01:49:24 CST

Original text of this message