This content has been marked as final. Show 3 replies
So, you are trying to force the user to enter the password a second time rather than using single sign-on? That seems like an unusual request-- the whole benefit of externally authenticated users is normally the ability to do single sign-on.1 person found this helpful
I don't believe there is any way to specify that you want an externally authenticated user but then have Oracle accept and authenticate the password.
Using an OPS$ account on Windows is a really bad idea given the many security issues in Windows. It is ok to use this technique with a robust operating system ... but Windows does not meet that criterion.
there's a little known feature that if (and only if) os_authent_prefix = "OPS$", as it is in your case,
you can give the user a password like this:
alter user "OPS$MY_DOMAIN\MY_USER" identified by my_password;
and then both OS authentication will work for local connections, and remote connections using @my_Database can use the password,
Harm ten Napel