Re: OS authentication with Oracle8i on Windows 2000 Professional

However, there is a registry setting - something like OSAUTH_DOMAIN_PREFIX (?)
that can be set to 'false' in which case the domain is not checked.

"Keith Boulton" <kboulton_at_ntlworld.com> wrote in message news:gS768.686$IY1.177275_at_news2-win.server.ntlworld.com...
> Had a similar experience with NT. In that case the account had to include
> the domain name e.g. user fred in domain test had to be created as
>
> create user "TEST\FRED" identified externally.
>
> I found the id to use by logging on as the NT account I wanted to use,
> logging in as e.g. system and looking at one of the fields of v$session
> (client_user?) which gives the OS account in use.
>
> F C <future_canadian_at_hotmail.com> wrote in message
> news:9fd389d6.0201301210.2d7d5302_at_posting.google.com...
> > I have problems performing OS authentication with Windows 2000
> > Professional. Oracle Server is installed on the same
> >
> > computer.
> >
> > Here are the steps I performed :
> >
> > Step 1 - logon Win2000 as 'administrator' and create a new user named
> > 'eddie'.
> >
> > Step 2 - check that my init.ora file has the following parameter
> > os_authent_prefix = "". (My sqlnet.ora file has the
> >
> > following parameter SQLNET.AUTHENTICATION_SERVICES= (NTS), but I
> > don'think it is relevant to my problem)
> >
> > Step 3 - connect as system/manager and create a new user :
> >
> > SQL> create user eddie
> > 2 identified externally
> > 3 default tablespace system
> > 4 quota 10 m on system
> > 5 /
> >
> > Utilisateur créé.
> >
> > SQL> grant create session, connect to eddie;
> >
> > Autorisation de privilèges (GRANT) acceptée.
> >
> > SQL>
> >
> > Step 4 - exit sqlplus
> >
> > Step 5 - restart windows 2000 and logon as 'eddie' (I also tried with
> > logging off administrator and logging on as eddie,
> >
> > without restarting Windows, the result was the same)
> >
> > Step 6 - at the command prompt
> >
> > D:\>sqlplus /
> >
> > SQL*Plus: Release 8.1.6.0.0 - Production on Me Jan 30 11:48:10 2002
> >
> > (c) Copyright 1999 Oracle Corporation. All rights reserved.
> >
> > ERROR:
> > ORA-01017: invalid username/password; logon denied
> >
> > Entrez le nom utilisateur : eddie
> > Entrez le mot de passe :
> >
> > If OS authentification was activated, I understand that I should not
> > be required to enter a username. However, when I
> >
> > enter the username, I am asked to enter a password that does not even
> > exist.
> >
> > Step 7 and + :
> >
> > I also tried : - the sqlplus command without the slash;
> > - the ops$ prefix with an ops$eddie username for Oracle and eddie
> > username for Windows
> > - the same process on another computer (also Windows 2000).
> >
> > Conclusion : it looks like Oracle does not recognize the Windows
> > username, unless I missed one or more steps.
> >
> > Has anyone encountered the same problem before? And most important,
> > how did you fix it?
> >
> > Thanks for your comments.
> >
> > Eddie J
>
>
Received on Thu Jan 31 2002 - 14:45:57 CET