- Check with Product Owners that password for user id can be reset
- Run the following query on the PCOC database:
select * from TC008_USER where USER_ID = '<User_ID>';
--Note the value of tc008_user_id below
update tc008_user set user_password_txt = '<random_password>' where tc008_user_id = <tc008_user_id>;
update tc008_user set date_expiry_password_dte = null, date_lockout_account_dte = null where tc008_user_id=<tc008_user_id>;commit;
Where <User_ID> is the username of the account
- Where <random_password> is any password that meets criteria below e.g.: Jkfds03-fefja
- Must be 8 - 20 characters in length
- Must contain one upper case and one lower case letter
- Must contain at least one number
- Must contain at least one of the following special character #$!*+@
- Must not contain spaces
- Use or Provide this password to the client, they will be forced to update on first login.