How to delete inactive users from JIRA


Version - 4.2.4-b591

I have 2 questions

  1. Upgrade path from 4.2 to 5.1 or latest
  2. We have thousands of inactive users - in JIRA 4.2 also do we have ability to deactivate user similar to 5.1? Is there a script which does automatically rather than manually doing that?
  3. Can we activate a deactivated user at a later time if they rejoin the group/work location.
  4. Does the issues assigned to deactivated user can still be accessed.


Bose Kamineni

3 answers

Hi @Bose Kamineni,

  1. I didn't get what you need.
  2. If you want to deactivate all users, you can do it through the database by setting the field 'ACTIVE' to 0 in the 'CWD_USER' table. note that you need to restart JIRA for this to take effect.
  3. You can reactivate any user at any moment.
  4. All issues assigned to deactivated users are shown normally


HI Bose!

  1. There is no specific upgrade path from 4.2 to 5.1 or latest. You can directly create a new application server at the new version then point it at your 4.2.4 database. ( for reference)
  2. Yes both version have similar way to deactivate users ( for reference). However, I have not heard of a script to automatically do that job.
  3. Yes you can activate a deactivated user at a later time, and the process is similar to deactivating process, like quoted from

    How to Deactivate/Activate User
    1. Locate the user in the User browser (see Viewing Users above) and click their Edit link in the Operations column.
    2. In the resulting form, clear the Active check box.
    3. Click Update to confirm the change.
      information To re-enable the user again, repeat the steps above but instead, select the Active check box.
  4. Yes, the issues assigned to deactivated user can still be accessed.

I hope my answers can clear up your question, and I wish you a good day!

Warm Regards,
Ezra A. R. A. 


You can always deactivate them in DB. Please try it on test JIRA instance before.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Fadoua M. Boualem
Published yesterday in Trello

Using Trello to manage events

As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...

447 views 6 7
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you