PGSQL:
update AaaPassword set password='$2a$12$fZUC9IK8E/AwtCxMKnCfiu830qUyYB/JRhWpi2k1vgWLC6iLFAgxa', SALT='$2a$12$fZUC9IK8E/AwtCxMKnCfiu' where algorithm='bcrypt' and password_id in (select ap.password_id from aaaaccpassword ap left join aaaaccount ac on ac.account_id=ap.account_id left join aaalogin al on
al.login_id=ac.login_id where al.login_id='3');
MSSQL:
update AaaPassword set PASSWORD='$2a$12$fZUC9IK8E/AwtCxMKnCfiu830qUyYB/JRhWpi2k1vgWLC6iLFAgxa', SALT='$2a$12$fZUC9IK8E/AwtCxMKnCfiu' where algorithm='bcrypt' and PASSWORD_ID in ( select AaaPassword.PASSWORD_ID from AaaPassword LEFT join AaaAccPassword on AaaPassword.password_id =
AaaAccPassword.password_id LEFT join AaaAccount on AaaAccPassword.account_id = AaaAccount.account_id LEFT join AaaLogin on AaaAccount.login_id =AaaLogin.login_id where name = 'administrator')
Note: These queries are applicable only if the password algorithm is 'bcrypt'(introduced in 9.3). After 9.3 upgrade, once the user logs in, the algorithm is updated from MD5 to BCRYPT and in certain cases, where if the user has not logged in post upgrade and forgot password, it still holds old algorithm MD5 , in this case, the old queries should be used. The below query can be used to find out the password algorithm used by the user,
select ap.PASSWORD_ID, ap.password, ap.algorithm,ap.salt from AaaPassword ap LEFT join AaaAccPassword on ap.password_id =AaaAccPassword.password_id LEFT join AaaAccount on AaaAccPassword.account_id = AaaAccount.account_id LEFT join AaaLogin on AaaAccount.login_id =AaaLogin.login_id where name ='administrator'