We did an data base upgrade from one version to an more recent version. Due to this our 'Work Space needed to be modified with the new database details.
We wanted to change the username and password for the various connections to point to the new database which involved adding the same 'keywork' at the end of all user names. However we were unable to do so on the Oracle Logon dialogue.
As a result we had to re-enter the user name and password to activate the connections.
Is it possible for us to access the user name and password on some file and make the changes, so we don't have to look through all the lists of database and password sets for each connection?
The workspace (.wsf) files hold your project information, including connection information. It stores the database name and user name. If you saved a password, this is stored in the registry, encrypted, and associated with the database and user name pair.
Automatic connection cannot be made if either database or user name is changed. The password will need to be reentered.
There does not seem to be a way to easily change your connection info for use with the new database and connect. You have access to the workspace file and can change the info found in that file. You can try to use it in Nav through the project manager for connection. But if it's a new database it will not be able to connect without reentering and saving the password again.
With a new database you will need to connect again and save the connection information again since the database has changed.
