I am very much confuse about this topic. I have been using oracle based database security but company now wants to handle with windows authentication.
I have windows os 2008 R2 and oracle 18.104.22.168.
I also have set up the SQLNET.AUTHENTICATION_SERVICES= (NTS)
I created user with create user "domain\username" identified Externally!!
but now how can i connection from application to database!!
Please guide or provide direction please!!
What language/ framework is the application using? What sort of connection string are you looking for?
Does the application support externally authenticated accounts? That may require some additional code to support.
You say the application is running on an app server. Does that imply that this is a three-tier application? Are you trying to get users on a client machine to connect to a middle tier server and then have the middle tier connect to the database using the Windows credentials of the user on the client machine? Rather than the operating system credentials of the Windows user that is running the middle tier application server?