nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Carlos Garcia Navarro

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

All comments

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.

Carlos Garcia Navarro

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!

Xiao Monica

Thanks for your attention!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

sql

jira-software

jira-software-server

user

inactive