Oracle 11g
Excel 2010
I have created an Excel program that accesses an oracle database (via VBA). I just found out my client does not have integrated security available to allow use of their Windows credentials. I need to find another method of authentication. Possibilities include:
1. Integrated Windows Security - Not available and not willing to purchase
2. Hard code username & password - Not allowed due to lack of security in Excel
3. Have Excel access another file containing credentials - Not allowed because the other file would not be secure and password could be retrieved by user using Excel
4. Have user enter username and password - not acceptable
I have been told:
The code behind the program will need to be modified to a secure the username & password. In addition the program needs to dynamically call app credential and encrypt
Is there any other method to fulfill this requirement?