| Problem with Domain-Prefixing on WinNT/8.0.5 [message #66270] |
Wed, 27 February 2002 14:36  |
George Hofilena
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
I wanted to implement domain-prefixing in authenticating users to avoid
users with similar usernames outside the domain from connecting using the
OPS$ authentication. So as per Metalink instructions, I created user jsmith
using, CREATE USER "OPS$OURDOMAINJSMITH" IDENTIFIED EXTERNALLY... and
granted the CONNECT role. jsmith is an existing domain user. I went to the
NT server Registry where the database resides and added
OSAUTH_PREFIX_DOMAIN=TRUE under the Oracle Key. SQLNET.AUTHENTICATION_SERVICES = (NTS) on both client and server.
When jsmith logged into the domain and tried connecting to the database
using SQL*Plus, he got this message:
SQL> connect /@test03
ERROR:
ORA-01017: invalid username/password; logon denied
Can somebody point out what I still need to do make this successful.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
