This topic is retained to support regression to releases of Enterprise Architect prior to version 7.1. For password encryption for all repositories at and beyond release 7.1, see the Model Shortcuts topic.
Users of SQL Server or Oracle repositories have the option of encrypting the password used to set up the connection between Enterprise Architect and the repository.
The Enterprise Architect user does not have the real password, thereby preventing them from accessing the repository using other tools such as Query Analyzer or SQLPlus. Once security is enabled, the administrator must log on to access the dialog to create encrypted passwords.
To encrypt a password, follow the steps below:
- Select the Project | Security | Encrypt Password menu option. The following dialog displays:
- In the example above, the password password123 is used to access the repository.
- To connect Enterprise Architect to the repository, the user enters the encrypted password prefixed with $$, so the encrypted password becomes $$qcvtyrsf435.