Re: Authentication Problem
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-lReceived on Thu Jan 31 2008 - 01:49:24 CST