We need to figure out how the authorization.I have a file - "validateuser.sql" in folder "sql".
File contents
validateuser.sql
<<id>> is the user ID entered on the device
<<password>> is the password entered on the device
<<previousUser>> is true if this is a "previous user" login.
<<password>> is valid for previous users.
This query should return a single row, unless PASS is used.
The column VALID can have the following values:
'TRUE' if login is OK (other rows and scripts are tested, and may invalidate).
'DB' if Agentry should attempt a database login with the password
The column DBID may specify a different ID for the database
'FALSE' (or NULL) if the login is not OK
'BLOCKED' if the user is blocked from logging in (makes client perform lockout)
'PASS' to allow processing to continue (another row or script must validate)
The column ERR may return an error message, 'Invalid Password' is assumed
The column USER_BLOCKED may be 'TRUE' for the same effects as VALID='BLOCKED'
The column PASSWORD_EXPIRED may be 'TRUE' to force user to change password
The column PASSWORD_WARNING may be 'TRUE' to promt user to change password (user has choice)
The column CAN_CHANGE_PASSWORD may be 'FALSE' to make PASSWORD_WARNING tell user about password,
but not allow password change from client.
See Agentry documentation for additional information.
-->
select 'TRUE' as VALID
<<database.singleRow>>
What "<<database.singleRow>>"? Where I can see the login script?
Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.