the web front-end for your database

Database Connections

Everything in dbFront starts with the creation of a Database Connection so this topic covers what is required to create and manage a database connection:

Database Account

Before you can add a database connection you will need access to a database account.   You can use any account with enough privileges but it is better to create an account specifically for this purpose.   A special purpose account will enable you to lock it down so that if there is a security breach then it will give the attacker the least possible privileges.

Other than the normal table privileges, this account will also need to be able to read the object definitions.

Add Connection

Once you have access to a database base account then creating the database connection should be straight forward.

dbFront create database connection

You will need to specify the:

  • Server name: The name or IP address or the server hosting the database,
  • Server Type: SQL Server, MySQL or Oracle
  • Username: The account created in the step above.
  • Password: This needs to be entered twice.

You can additionally create a more friendly caption for the database connection.  This will be visible to other admin users.

The button named "Test" will test the connection without saving it.  The "Save" button will save the connection after first validating it.

If there is a problem creating a connection then you may need to review the setup article related to your database:

Connection Preferences

Once the database connection has been created

If you ever need to update the connection credentials or caption then this can be done from the Connection Properties dialog.  You will be required to enter the connection password to verify your access.

Connection Access

Once the database connection has been setup, one of the next steps would be to specify which users have access to that connection.   You might want to wait with that step until your application is ready.

To manage the access to your application please see: Connection Access.

Next Step

The next step is to finish the authentication setup and then update the preferences for the databases the connection made available: Database Preferences

Content you want the user to see goes here.
close