-
You're saying when your program accesses the Oracle database, the user is prompted for a login name and pw??? That doesn't seem right.
You can pass a login name/pw to the Oracle DB in your connection string (assuming you are using ADO), as follows:
cnnDB.Open "Provider=MSDAORA.1;User ID=YourID;password=YourPW;Data Source=YourSource;"
This way the user should never be prompted to login when they access a database of any kind...it should all happen transparently through the code.
-
Is there a way for the VB program to use the same security as the Oracle database? We don't want the user to have to login multiple times to the program, but they have to login to the server with NT, and the database within the program is in Oracle so they have to login to that too :|
Any ideas/suggestions???
