Unable to Delete a User that Has Never Logged in

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

A user cannot be removed from Confluence administration panel.

Cause

Unusual characters in the name can cause the username to fail to be removed.

Resolution

Always backup your data before performing any modifications to the database.

Provided that the user has never created content, the user can be deleted from the database. Content can range from page, comment, blog posts, space, watches, user info, and so on.

If the user has created content, you need to remove the content first before following the queries, or you may change the owner of the content using some of the queries in How do I change a username prior to Confluence 5.3. Please note that there is no support for renaming users or re-associating content in this fashion.

  1. Retrieve the user id and user name and find out whether s/he has logged in or not:

    select * from users where name like '%username%';
    
    select * from OS_PROPERTYENTRY where entity_id=<user id from previous query>;
    
  2. Presumably if the user hasn't logged in then they wouldn't have created a content, however, to be safe, see if this query returns any rows:

    select * from content where creator like '%username%';
    
  3. Check to see if a user info entry (i.e. user profile) exists in the CONTENTtable, then remove it:

    select * from content where username like '%username%';
    
    delete from content where username = 'user name you want to remove';
    
  4. Remove the user from the LOCAL_MEMBERS table and USERStable:

    delete from local_members where userid=<user id from the first query>;
    
    delete from users where id = <user id from the first query>;
    
Last modified on Feb 26, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.