Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Disable users from Confluence database


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

2 answers


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.

0 votes

Do not make changes to an Atlassian application's database.  You need to know exactly what you are doing (depending on the version, you've started in the right place, but I suspect, missed things), and you should always have the system offline, and backed-up with a proven restoration before you attempt it.

You might want to try a restart, but I suspect you really want to undo what you've done and then de-activate the users properly, through the UI.

Hi Nic, 

Thank you for your answer. 

I have created a Confuence test instance and I've attached a copy of the production database .  At the moment I'm testing this in a separate instance than production where I have the same configuration and a copy of the production database. 

I have to deactivate more than 200 users and deactivating them one by one from UI it's not an option smile 


Good, I was hoping you were in test.

I've said "use the UI", but what I really mean is "use the API" - your database approach is poor and broken (there really should be a banner across every Atlassian site saying "don't touch the database"), but the UI sits on top of an API which is safe to use.  The API is also accessible via plugins and REST calls from external systems.  This is the sort of thing I'd be scripting.

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.

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... (

Suggest an answer

Log in or Sign up to answer
Community showcase

The benefits of using Jira in different departments

Jira is a great tool to use across different departments. Forget that paperwork – switch to Jira and get that tasks done smoothly. Marketing Jira allows for a complete digital transformation of you...

36 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you