000011858 - BackOffice Tools 'admin' user password reset in RSA Adaptive Authentication (OnPrem)

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Feb 22, 2018
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000011858
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Product/Service Type: Adaptive Authentication (OnPrem)
IssueAdmin user account password reset.
ResolutionCurrently, in AAOP v6.x and v7.x 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

v6.x:
UPDATE USERS SET COUNT_TRIES = 0, LOCKED_AT = NULL, LOCKED_BY = NULL, SALT_VALUE = NULL, PASSWORD = 'D033E22AE348AEB5660FC2140AEC35850C4DA997' WHERE (NAME = 'admin');

v7.x:
UPDATE USERS SET COUNT_TRIES = 0, LOCKED_AT_DATE = NULL, LOCKED_BY = NULL, SALT_VALUE = NULL, PASSWORD = 'D033E22AE348AEB5660FC2140AEC35850C4DA997' WHERE (NAME = 'admin');
Legacy Article IDa50373

Attachments

    Outcomes