Re: OS authentication with Oracle8i on Windows 2000 Professional

Hello,

You have to enter it by yourself
(I think in the Software\Oracle\home tree) Its an Oracle Setting.

HTH
Stefan Kapitza

future_canadian_at_hotmail.com (F C) wrote in message news:<9fd389d6.0201311949.58375665_at_posting.google.com>...
> Thanks for your comments.
>
> I logged on Win 2000 as eddie and connected as sytem/manager on
> Oracle. I queried the v$session view and found ordipapa\eddie in the
> OSUSER column. Actually, ordipapa is the name of the computer and not
> the domain name.
>
> I created a new user as CREATE USER "ordipapa\eddie" IDENTIFIED
> EXTERNALLY and granted CONNECT and CREATE SESSION privileges to that
> user. No problem.
>
> I logged off and on again as eddie and entered 'sqlplus /' at the
> command prompt.
>
> I got the same message prompting for a username and then a password.
>
> I previously checked the oracle_sid parameter.
>
> I also tried to find the registry setting that disables the domain
> check. I assume it is a Win2000 setting. Can you tell me where to find
> it?
>
> Eddie J
>
> "Keith Boulton" <kboulton_at_ntlworld.com> wrote in message news:<b%i68.4686$sU.692003_at_news6-win.server.ntlworld.com>...
> > 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.
> > > >
Received on Fri Feb 01 2002 - 14:54:54 CET