Authenticating Oracle users with Windows NT

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 6 Apr 1999 12:59:23 GMT
Message-ID: <01be8036$322816f0$2c289a0a@apollo>

I have gotten Windows NT authentication to work by doing as follows:

OS_AUTHENT_PREFIX = '' (in initsid.ora) SQLNET.AUTHENTICATION_SERVICES = (NTS) ( in sqlnet.ora) and users created as follows
CREATE USER myUser IDENTIFIED EXTERNALLY where myUser is also a NT user.

This works fine. When I am logged in to NT as myUser I have acces to Oracle as myUser.

However, I would like to access Oracle as myUser, when logged in to NT as somebody else.
I suppose I should just create the user this way: CREATE USER myUser IDENTIFIED BY myPasswd If I do this I cannot get NT to authenticate myUser?

What am I doing wrong?

Thanks
Peter Received on Tue Apr 06 1999 - 07:59:23 CDT