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:
- Setting up the Database Account
- Creating the Connection
- Updating the Connection Preferences
- Setting the Connection Access
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.
Once you have access to a database base account then creating the database connection should be straight forward.
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:
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.
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.