This SQL statement is executed whenever a policy state entry
for a username needs an update. It is also executed when
AddQuery
is not defined and policy state needs to be
added. It is expected to record the details of both consecutive and
cumulative counters, policy violation and current window time in the SQL
database. Special formatting characters are replaced as follows:
- %0 with the username
- %1 with the
FailurePolicyContext
parameter
value
- %2 with the current consecutive failures
- %3 with the current consecutive failure window end timestamp
- %4 with the current consecutive lock end timestamp
- %5 with the current cumulative failures
- %6 with the current cumulative failure window end timestamp
- %7 with the current cumulative lock end timestamp
There is no default and
UpdateQuery
is not
run.
UpdateQuery
supports SQL bind variables with
pdateQueryParam
. See the sample configuration file
goodies/failurepolicy.cfg
for an example query. For
more information about bind variables, see
Section 3.8.1. SQL bind variables.