Encrypted password question....
843811Jul 27 2001 — edited Jul 31 2001
We are using both ADO and JDBC to connect to an Oracle database and my job is to make sure that the connect password that travels to the Oracle database is encrypted and not traveling in clear text. How do I encrypt this password before sending to the Oracle database? I think Oracle looks in its system table, SYS.USER, where this password is encrypted (I looked :-)) and then does it authentication stuff.
I would think that the Oracle ODBC drive would have an option I could set that would send all connect passwords to the Oracle database encrypted instead of in clear text but, I can't find one. And I looked in the ADO documentation and it looks like ADO sends the password in cleartext and there is no option to send passwords encrypted.
Thanks for any help,