Re: OS authentication with Oracle8i on Windows 2000 Professional

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 Thu Jan 31 2002 - 21:49:38 CST