4/20/2015

HASH for password "P@ssw0rd"

If you want to reset password to "P@ssw0rd" for any user, for example for maxadmin user, you have to update field "password" in table "maxuser" by value "0xA587F52BA133CA479D56F780F84840BC" using CONVERT function.
use maxdb75;
update maxuser set password =
CONVERT(VARBINARY(128), '0xA587F52BA133CA479D56F780F84840BC', 1) where userid = 'maxadmin';
p.s.
only for maximo internal authorization, SQL Server