In releases of Enterprise Architect prior to 7.1, Security Administrators of projects on SQL Server or Oracle repositories can encrypt the password used to set up the connection between Enterprise Architect and the repository. The system user does not have the real password, thereby preventing them from accessing the repository using other tools such as Query Analyzer or SQLPlus.
For password encryption for all repositories at and beyond release 7.1, you provide the connection but protect the password using model shortcuts.
Configure > Security > Administer > Encrypt Password
Encrypt a repository password
In the 'Password' field, enter the password to access the repository.
The 'Encrypted' field displays the modified password to be provided to users.
Instruct users to connect Enterprise Architect to the repository using the encrypted password prefixed with $$.
|Connect to an Oracle Repository (ODBC) Connect to a SQL Server Repository
- Do not click on the as it can cause an error with encrypted passwords
- For SQL Server repositories, you must enter the Initial Catalog details from the 'All' tab of the 'Data Link Properties' dialog