Set users inactive via SQL doesn't work?

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.

2 answers

Community moderators have prevented the ability to post new answers.

1 vote

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thanks a lot!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Like • Carlos Garcia Navarro likes this

1 vote

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thanks for your attention!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.