Reset Account Password in DB

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.