Loftnisse of Jobzone
8/5/2019 - 12:11 PM

Set password

Sets password to 'Passord1' on a customer or candidate login

These scripts will set the password for all contactlogins to 'Passord1'. If you need to login to their profile in a test enviorment, add the where statement to the script if you only want to reset one password.

The snd script will change the passord for a candidate login to 'Passord1'. The were statement is in this script because if you run it without the script will use up to a minute to finish due to triggers lying on the KANDIDAT table. I do not recomend updating all candidate logins unless its for a reason.

SetPassord
content_copyfile_download
update ContactLogin
  set PasswordHash = 'UiAGf9DlWF+/Yvh9wTVPFzzHHNG8TcoWdRm0Dr6Jfo7wHAbH/Ttz+1hkK3jc1UCmLZMlaWiolfDzbGtKJP4nIhYhQp/WmWo3urLQBOLij7gb0QCT+YPsBnfY0ukCjY99LPOFf+K8PlSfqi+2E6ZkHczttEJqgwZ1xFo7Bw68mJs=',
      Salt = 'aTUN7Usa0iB2ATzIEb7tKCuJjhT/qtXUS1f4laoqlKtX4Sat9Pah1e+syb1ws+xbTJr2ub3wYmOZ8JDqGFydYoABh2p9c5yywTXXtoojBmN9tbWTrfv0ide3R9YKucJEOlYiz0PCO7FoZEKCx77zxYArZjzSAA9c0bUKQze+01E='
Candidate login
content_copyfile_download
update KANDIDAT
set PASSWDHASH = 'UiAGf9DlWF+/Yvh9wTVPFzzHHNG8TcoWdRm0Dr6Jfo7wHAbH/Ttz+1hkK3jc1UCmLZMlaWiolfDzbGtKJP4nIhYhQp/WmWo3urLQBOLij7gb0QCT+YPsBnfY0ukCjY99LPOFf+K8PlSfqi+2E6ZkHczttEJqgwZ1xFo7Bw68mJs=',
SALT = 'aTUN7Usa0iB2ATzIEb7tKCuJjhT/qtXUS1f4laoqlKtX4Sat9Pah1e+syb1ws+xbTJr2ub3wYmOZ8JDqGFydYoABh2p9c5yywTXXtoojBmN9tbWTrfv0ide3R9YKucJEOlYiz0PCO7FoZEKCx77zxYArZjzSAA9c0bUKQze+01E='
where ID = 461983