|Issue||Admin user account password reset|
|Resolution||Currently, in 220.127.116.11/SP1 there is no way to recover the password for "admin" user account if it's lost/forgotten.|
The sql below will reset the password of this "admin" account to the default value "admin".
Run the sql against the Back Office Tools DB while logged in as the schema owner
UPDATE USERS SET COUNT_TRIES = 0, LOCKED_AT = NULL, LOCKED_BY = NULL, SALT_VALUE = NULL, PASSWORD = 'D033E22AE348AEB5660FC2140AEC35850C4DA997' WHERE (NAME = 'admin');
|Legacy Article ID||a50373|