Skip to Content
0
Former Member
Aug 09, 2016 at 10:44 AM

Authorization

28 Views

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!