I thought I'd read in the documentation that you were strongly recommended
not to do this?
timkarnold <timkarnold_at_home.com> wrote in message
news:pUb68.18300$8d1.6859720_at_news1.rdc1.md.home.com...
> 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 - 15:55:49 CST
