Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OPS$ login under NT
How are you creating your Oracle Users.
You should use IDENTIFIED EXTERNALLY option while creating Oracle users.
Example:-
Create user manoj identified externally;
Make sure the users are created this way, else this it wont work.
Also make sure Oracle User Name is same as Operating System User Name.
Hope this helps,
Manoj Jain
Oracle Certified Professional - OCP DBA
Chauncey Certified Oracle7 DBA
In article <6u8p3d$16903_at_tmpsp002.tmpprv.allied.com>,
"Zachary Agatstein" <Zachary.Agatstein_at_atsc.allied.com> wrote:
> I have a problem implementing an OPS$ login to Oracle Workgroup Server 7.3.4
> running on Windows NT domain. I set the prefix to none, and enabled remote
> OS authentication, so I have these two lines in initxxxx.ora:
>
> OS_AUTHENT_PREFIX = "" (set of double quotes)
> REMOTE_OS_AUTHENT = TRUE
>
> The intent is for any logged on NT user to connect to the database by using
> only a "/" instead of his/her username/password, followed by
> @database_alias. For example, from inside SQL*Plus, this would be a
> "connect / @dbalias" command
>
> Of course, users, with usernames matching these in the NT domain and
> identified externally, have been added to the database.
>
> I still cannot connect. What am I doing wrong? I remember that under Unix
> this was a piece of cake.
>
> Zach Agatstein
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 22 1998 - 17:00:51 CDT