Setting Common Authentication Options

DbVisualizer lets you handle authentication in a manner that suits your balance between security and convenience.

Userid and password information is generally information that should be handled with great care. By default, DbVisualizer saves both the Database Userid and Database Password (encrypted) for each database connection. The default for SSH is to save the SSH Userid but not the SSH Password (or Key Pass-phrase). You can change this behavior to fit your preferences. You specify how to handle the Database Userid and Password in the Authentication category of the Properties tab. The same options are available for the SSH Userid and Password in the Database Connection/SSH Settings category in the General tab of the Tool Properties window.

The Require Userid and Require Password properties can be enabled to tell DbVisualizer to automatically prompt for userid and/or password when a connection is to be established if they are not specified for the connection. The following dialog is displayed if requiring both userid and password.

Since a password may need to be handled with great care, you can also specify for how long it should be saved, if at all. If Clear at Disconnect is selected, DbVisualizer ensures that the Password field is cleared as soon as the connection is terminated. With Save During Session, it is cleared when you shut down DbVisualizer. To keep the password between sessions, select Save Between Sessions. If you use Save Between Sessions, we recommend that you also set a Master Password.