How to determine saved passwords for Oracle tables linked to an MS Access front end
Posted on 2011-03-10
I have inherited several MS Access databases where Access serves as a front end to an Oracle 10g database. All of the tables were linked with the "save password" option. I am adding new tables and would like to keep the uid/pwd consistent rather than just create a new user in Oracle. I can hover over the linked table names in MS Access to see the connect strings and find the correct UID, but the password is not displayed (that I can tell). Documentation is lacking and the former DBA/programmer has disappeared so I can't ask him what the current passwords are and none of the users has a clue what their password might be since they have never been asked to provide it. When linking tables with the save password option, a caution message states that the passwords are saved as regular text, so I know they are SOMEWHERE, but I can't find them. Can you tell me how to locate the saved passwords?
Alaska SeaLife Center