Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to effectively deactivate a Jira user with automation ?

Eddy Fras
Contributor
January 4, 2019

I'm trying to deactivate some selected users but for an unknown reason that does not work.

I used the update SQL request I found here : https://community.atlassian.com/t5/Jira-questions/Bulk-User-Deactivation-in-Jira/qaq-p/313925

When I check the DB, active flag is set to 0.

# select user_name, display_name, active from cwd_user where user_name = 'test@external.com';
user_name | display_name | active
-------------------+--------------+--------
test@external.com | prenom nom | 0

But in the user management console, user is still active (not striked through) as shown in screenshot. 

activeuser.PNG

What do I have to do to get my users really deactivated ?

Thanks,

Eddy

1 answer

0 votes
Kenny Horan January 4, 2019

One possibility, Hibernate caches data so that row is likely cached in Jira.  Restarting Jira would flush it.

Eddy Fras
Contributor
January 4, 2019

Thanks Kenny for your quick answer. Unfortunately, I can't restart Jira for now, I have some users playing with it :)

I'll see if your suggestion is the right one the next time I'll restart it.

Eddy

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events