|Tablename Prefix||When set to Automatic mode, this property determines the prefix that will be used on all automatically created tables. Useful when multiple database User Sources are connected to the same database scheme.|
A query that must return a row if the given username and password combination provided is valid. The query will run as a prepared statement, so use the question mark character (?) to represent username first and then password. The returned row may contain the user's basic properties under the column names: [firstname, lastname, schedule, language, notes]
Note that the Gateway will pass both the username and password the user typed in, so this query MUST utilize exactly two question marks, otherwise an exception will occur.
|List Roles Query||A query that returns all possible roles that any user could be a member of. The role names must be returned in the first column of the query's results.|
|User's Roles Query||A query that returns all of the roles that the provided user belongs to. The roles must be strings and must be in the first column of the query's results. The query will be run as a prepared statement with one parameter: the username.|
|List Users Query|
A query that returns a row containing each username. There must be at least one column: the username. Other columns are optional, supported columns are: [username, firstname, lastname, schedule, language, notes].
|Contact Info Query||A query that returns all of the contact info for the user. The first column must be the contact type, the second column the contact value. Optional, may be blank.|
|Schedule Adjustment Query|
A query that returns the upcoming schedule adjustments for the user. This property is optional, and may be left blank.
The results set expects the following columns:
|Extra Properties Query||A query that returns name, value pairs of extra properties for the user. Will be run with one parameter: the username. Optional, may be blank.|
When finished, click Create New User Source.
The tables in the database will not be created in the database until they are needed. For example, as soon as a user or role is added, the associated tables will automatically get created.