LDAP/Active Directory Single Sign-On for Oracle
Posted on 2009-07-14
Sorry to post an almost-duplicate question, but since I already marked my last question as answered...
I wan't to implement a single sign-on solution where users will automatically be logged in to Oracle using their Windows login without the user having to type their username/pw again. I have implemented this and it was quite easy to do if both client and DB server are Windows XP machines. Now, though, I need a solution that will work if the DB server is on a UNIX box. Through my research online I have found that I may need to use LDAP for this, but from what I understand, that will only allow users to manually login using their Windows credentials whereas I am hoping to find a solution where they do not need to re-type their password to connect to Oracle if they have logged into windows. Is there a way to have users connect to Oracle using their Windows account WITHOUT REQUIRING A PASSWORD when the database server is on a UNIX machine? (I want to be able to just say connect /@dbname like I can with my Windows solution. Will LDAP let me do this?)