We invite you to participate in the 2024 Project to Product State of the Industry Survey. Complete this brief survey and be among the first to receive a copy of the 2024 Project to Product State of the Industry Report. Click here to start the survey!

How to mass update resource passwords

Last updated
Save as PDF

QUESTION
We used windows authentication for Changepoint, not the application authentication so we do not use the password field on the user set up screen. However, we have a need to mass update this field. I see it's an encrypted column in the database so don't think I can just do an update statement. How can I update this field for everyone? Manually setting it is not an option due to the effort required.

REASON
Mass update for passwords are not currently possible as the encryption cannot be done through a SQL statement. Also, the encryption uses resource specific information so passwords cannot be copied from one resource to another.

RESOLUTION
Password mass update would need a customization/customer specific script or program.