Unable to Delete a User that Has Never Logged in
A user cannot be removed from Confluence administration panel.
Unusual characters in the name can cause the username to fail to be removed.
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.
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>;
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%';
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';
Remove the user from the
delete from local_members where userid=<user id from the first query>; delete from users where id = <user id from the first query>;