Howto make Oracle using authentication by "OPS$DOMAIN\USER"?
Hello,
I'd like to get externally user authentication running with regards to the domain the client is using.
So I've created a user using
SQL> create user "OPS$DOMAIN\USER" identified externally;
But I fail to connect from a client logged in with that domain account. I created another user "OPS$USER" and now I can login. My client system uses an AD domain account for logging in to the client and that account is logging in to oracle as "OPS$USER" and not as "OPS$DOMAIN\USER" as it should be.
How can I change this behavior to distinguish between local and domain users?
The parameter os_authent_prefix is set to "ops$" and remote_os_authent is set to true.