Authentication is one of most basic but also important functions of dbFront. dbFront includes a number of options for validating users and ensuring that they have only the necessary access to your databases, tables or data rows.
Note: This topic does not cover setting up database connections. Connecting to the database is covered in Database Connections. This current topic specifically covers users connecting to dbFront so that thay can access the applications created based on your database connections.
Windows Active Directory
If you want to manage your access based on Windows Active Directory then you would setup the dbFront Service to point directly to your domain. Additionally you would setup groups to restrict access to dbFront, both for administrators and regular users. For more information see: Windows Authentication.
Note: Windows Authentication is the default authentication in dbFront. Windows Authentication is also required for all Administrative users. For more details see: Windows Authentication.
If your source of users is contained in a Database then you can setup dbFront so that it will validate users using a stored procedure. For more details see: Database Authentication.
In addition to both of the above options, you can use the requirement for a Database Profile to restrict or manage user access to individual databases. For more details see: User Profiles.
Table and Row Security
dbFront has several options when it comes to managing table access but the best and most secure way to manage Table Security is at the database level. For more details see: Table Security
dbFront also allows you to limit the user access to specific Table Rows. For more details see: Row Level Security