Set users inactive via SQL doesn't work?

[Xiao Monica]

I have set active=0 for the users in cwd_user table. But it doesn't work even after I restart the JIRA service. 

How to set users inactive via SQL? Please help.

[Carlos Garcia Navarro · Accepted solution]

As of Jira 8.3.0, you could use an API call:

https://docs.atlassian.com/software/jira/docs/api/REST/8.3.0/#api/2/user-updateUser

[Xiao Monica]

Thanks a lot!

[Nic Brough -Adaptavist-]

Do not use SQL to do this, it's the worst possible thing you can do, as you can tell, as it's not worked for you.

[Xiao Monica]

Thanks for your attention!