Database Authentication
Add an additional authentication profile to store user information using an existing database connection. This video addresses the internal authentication profile Failover Source and the differences between a Hard and Soft Failover mode. It also includes information about the automatically created database tables.
Database User Source
The database user source uses an external database connection to find its users, their passwords, and their roles. When you create a database user source, you have the option of setting it up in automatic or manual modes.
Automatic Mode
In this mode, the user source will create and manage the database tables for you. In this mode, the user source will be fully manageable from the Gateway and the Vision Clients using the user management component. You can specify a prefix for the tables that are created, but their names after the prefix are chosen by the user source.
Manual Mode
In this mode, you must provide SQL queries for various functions of the user source. In this mode, the user source will not be manageable from the Gateway or the Clients. You'll have to manage the users yourself directly through the database. Examples for each of the queries are given on the user source setup page. Make sure to return the columns that are defined in each query's description.
Failover Mode
Hard
Hard failover mode means that if the source isn't available at all, go and check default.
Soft
Soft failover mode means that if the user typed the wrong password and failed to authenticate, go and check default.