If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Need VBA code to do pass-through authentication from Active Directory to an Oracle database

Thread starter WVTech
Start date Apr 23, 2014
Tags

active directory oracle pass-thru authentication vba

WVTech

New Member

Apr 23, 2014

I have a query in VBA code, to pull data from an Oracle database into Excel. That code works fine, but I have to prompt the user for their username and password every time they run the query, to authenticate them to Oracle. The user's Active Directory credentials and their Oracle database credentials should always be the same. So, rather than have the user enter their Active Directory/Oracle username and password every time they run the query, I would like to do pass-through authentication of the user, (currently logged into Active Directory), sending their credentials to the Oracle database. Can someone please help me with the VBA code to do this? Thank you.