Microsoft 4.5.X Manuale Utente

you do not need to enter a setting query. If this checkbox is checked, you will need to enter a
setting query. The Account Reset Console uses this query to set the answer in the database
when the user configures his identity verification answers.

Insertion queries are only required for verification questions whose answers can be set by the
user.  If the “Allow users to set their own answers to this question” checkbox is not checked,
you do not need to enter an insertion query.  If this checkbox is checked, you will need to enter
an insertion query.  The Account Reset Console uses this query to add a user to the database
when an appropriate entry for that user does not exist.

User deletion queries are only required for verification questions accessing databases which
should be “cleaned up” periodically, that is, have inactive or nonexistent accounts removed.
The Account Reset Console currently does not utilize this query.

Designing Queries

Queries should be in SQL. Before the Account Reset Console sends the query language to
the data source, it will perform the following substitutions in the query string:

String

Replaced With

Example

#user#

The username (without domain)

bob

#domain#

The user’s domain

SALESDMN

#question#

The GUID of the question

3C1D8B25-D423-
419B-AD6E-
E78169B89374

#answer#

The text of the answer

Blue

When the Account Reset Console performs this replacement, it does not insert (or remove)
quotation marks or other tokenizers. Thus, if you have a character-valued column and you
want to look up the user name in that column, you will probably have to enclose the #user# in
quotes:

…where user_name_column = ‘#user#’…

When retrieving the answer from the data source using the retrieval query, it will take the value
in the first column of the first row of the retrieved recordset as the answer to the question. You
may return any number of rows or columns, but only the first cell will be utilized by the Account
Reset Console.

When you click “Save Question Settings,” the Account Reset Console will attempt to retrieve
the answer for the specified test user from the data source you have selected, using the
retrieval query you have entered. It will also attempt to set that user’s answer, using a
predefined test value.

If you have selected the checkbox “Allow users to set their own answers to this question,”
users will be allowed to enter an answer to the question in the “Set Up My Identity” tab
(described earlier in the document). Users will only be prompted to enter answers to questions