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.