Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Authenticating Oracle users with Windows NT
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