Set Connection Details and Policies

Overview

You have the flexibility to configure specific details and security parameters for each connection, as well as define access restriction policies based on various factors such as time of day, day of the week, and maximum data access limits. These settings can be configured during the connection registration process for added control and security.

Set Connection Details and Policies

1. In the Database Settings menu, navigate to the DB Connections menu.

2. Select the connection you have previously registered.

3. Scroll down to the Additional Information section located at the bottom.

4. Here, you can input various details and configure policy settings:

   1. Max Display Rows : Limit the maximum number of rows retrieved after a query execution.

   2. Max Export Rows : Specify the maximum number of rows allowed for data export.

   3. Access Start Time : Set the start time for connection accessibility based on the time zone.

   4. Access End Time : Define the end time for connection accessibility within the specified time zone.

   5. Weekday Access Denied : Choose the days of the week when the connection should be inaccessible.

   6. Maximum Login Failures : Restrict the number of failed login attempts permitted for this connection.

   7. Specified Time interval Before Lockout : Define the time interval used to determine the allowed number of failed login attempts.

   8. Database Version : Enter the version of the database utilized by this connection.

   9. Label : Indicate whether the connection is a ledger database or not (Default = Normal)

      ※ Setting Label to “Ledger” will enforce the DML Snapshot option.

   10. Query Audit On/Off : Toggle to log queries executed on this connection (Default = On).

   11. DML Snapshot On/Off : Toggle to record before and after data changes on this connection (Default = Off).

   12. Proxy Usage : Specify whether to utilize a proxy for this connection. Refer to Proxy settings for more details.

   13. Character Set : Choose the character set to be used for this connection.

   14. Collation : Select the sorting method for the chosen character set.

   15. Description : Optionally, provide a description for this connection.

5. Click the Save Changes button in the upper right corner to confirm and save your settings.

Use SSL Connections in Connections

Registering an SSL certificate for each connection ensures secure communication, and QueryPie fully supports SSL connections.

1. From the Settings menu, navigate to the Connection Settings > SSL Configuration menu.

2. Click on the Create SSL button located in the upper-right corner.

3. Provide the following details to register an SSL certificate:

   1. Name : Assign a name to identify the SSL certificate.

   2. SSL Mode : Choose the connection mode for SSL.

   3. Private Key : Enter the key necessary for encryption/decryption.

   4. Certificate : Input the certificate details to identify the client.

   5. CA Certificate : Provide CA certificate information for certificate verification.

4. Click Save to confirm the SSL certificate enrollment.

5. From the Settings menu, proceed to Connection Settings > Manage Connections menu.

6. Select the desired connection from the list and scroll down to the SSL / SSH Settings section.

7. Enable the option for Use SSL for SSL connections.

8. In the SSL Configuration section, select the SSL certificate you previously registered.

9. Save your changes by clicking the Save Changes button.

Related Topics

• Synchronize DB Resources in AWS

• Access DB & Server via Proxy

• Enable Database Proxy

Back to DB Management