Deleting users in JIRA DB

[Sandeep Vellore]

I have few users who have been removed in the Active Directory list. I want to remove those users from the JIRA DB.

What is the process to do that?

Can i directly go and delete the users from APP_USERS & CWD_USERS tables?

[Dick]

Hi Sandeep,

If your instance is taking users aboard from an Active Directory and the users have been deleted there, they get an [x] indication in their name in Jira and they get marked in the database as being inactive. 

There is no need to delete them any further (other than to clean-up your DB).

[Sandeep Vellore]

Thanks for the response. How do i clean up these users from the DB? Just delete them from the two tables i mentioned earlier?

[Dick]

Atlassian's solution (safest) is described here: 

how-do-i-disable-remove-inactive-active-users-in-bulk-1093012826.html 

it also states there that the required functionality is under consideration in their backlog.

Issue JRASERVER-8047 You might want to follow that or at least vote for this issue to provide more incentive to Atlassian that this is a feature to be working on.

[Zuri Suwru]

Hey there Sandeep,

You might want to take a look at this knowledge base article, however I'd suggest you double check whether this really is a step you have to take. Besides the fact that we are talking about a manual database operation, depending on your company's country of origin, this could also lead to auditing issues.

Best regards,
Zuri S.

[Bibek Behera]

@Sandeep Vellore ,

To start with please make sure that the users are not associated to and issues/dashboard/filter/automation that are used by existing active users.

+ This thread can help you going forward https://community.atlassian.com/t5/Jira-questions/Fully-Deleting-Users-From-Jira/qaq-p/1655349

-Bibek