Disable users from Confluence database

Question

Hello,

I want to disable the users that haven't logged lately in Confluence from the Database. Since there are too many users that I have to disable, I was looking to disabled them from the database.  I saw that the ACTIVE column from CWD_USER table is set to "F" if the user is inactive and with "T" if the user is active.

I set  ACTIVE  to "F" but when I've checked in Confluence, the users are not disabled.

Can you please explain what represent ACTIVE column from CWD_USER table and how can I disabled the users from the database?

Thank you

Ann Kristin · Answer

But is there any way to disable or deactivate users from REST or SOAP-API for Confluence? 
For Jira it can be done with REST, but it seems to me that Confluence don't offer this solution... (https://jira.atlassian.com/browse/CONFSERVER-54928)

Chip Smith · Answer

David,

What was the command line string that you used from the mysql prompt to do this? I am running into the same issue that you have, perhaps this is still fresh on your mind or you have documentation for it.

Thank you for you help.

davidbodle · Answer

Thank you, but after I've restarted Confluence all the changes that I did on the database had effect. All the user with ACTIVE set on "F"  are now disabled in the Confluence UI. I'll keep in mind the option with API in order to avoid database changes.

Thank you for your help.