How to Force All Users to Change Their Password

Still need help?

The Atlassian Community is here for you.

Ask the community

Overview

Crowd currently does not have a feature for administrators to force all of the users or users from a specific directory to change their password. In order to force a user to change their password, Crowd administrators have to do the following for each user:

  1. Navigate to Users
  2. Find the user
  3. Select 'Attributes'
  4. Set requiresPasswordChange parameter to "True". 

As you can see, following the steps above for every user can get tedious. There is a feature request created for this at  CWD-3332 - Getting issue details... STATUS , but in the meantime, you can set requiresPasswordChange to "True" for all users via the database by following the steps below. 

Steps

  1. Create a database backup of your Crowd instance, as a safety precaution
  2. Execute the following SQL and take note of the directory ID that the newly imported users were imported from:

    SELECT * FROM cwd_directory;
  3. Using the the directory ID, execute the following SQL query:

    (!) This will force all users from the directory to change their password
    UPDATE cwd_user_attribute SET attribute_value = 'true' WHERE attribute_name = 'requiresPasswordChange' AND directory_id = <INSERT DIRECTORY ID>;
  4. Once the SQL is executed, users will be prompt to change their password via the Crowd Console



Last modified on Feb 25, 2015

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.