Manage User Accounts

Owned by Asuquo Eniang
Last updated: Dec 13, 2019
2 min read

Block an Account from Reset

Background: A course provider organization can have multiple user accounts for each staff working for them, and 1 service account used to connect to the online test service. Sometimes they accidentally reset this service account, without updating the connection that uses that account. This causes online services to stop working. To prevent this, PO asked for some way to block those special service accounts from being reset. Individual accounts can still be reset without affecting service access.
Solution: A new role was created in the system named: Course Provider – Test Online API Account with role code CT. When a user account is assigned this role, it can not be reset. Any edits have to be done in the DB. The PO or someone from the PCOC Project Team can submit a service request for this. To update a user to this role, Run the following query with '<UserName>' , the user name to be blocked:

UPDATE tc008_user
SET
user_role_cd = 'CT',
access_exam_to_ind = 1
WHERE
user_id = '<UserName>';

COMMIT;

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.

Create a Course Provider - Test Online API account

  • Log in as a TC or SA user to the web application
  • Create a new user, select Course Provider - Test Online API account for the role
  • This sends an email to the PCOC Project Team, to request a password reset for the new account, from support
  • Follow steps in Reset Account Password DB section above to reset a password