delete local confluence user

[Will Lear]

Hi, 

We are running an onprem server Confluence 7.6.2 (with an AD as primary directory) and looking to migrate out to cloud, have hit a snag where I have 2 local user (not AD accounts) with the same email address. 

I have disabled the AD directory , moved the local directory up the list and then logged in with a local admin user account.

I was expecting to be able to delete the local user as per these instructions

https://confluence.atlassian.com/doc/delete-or-disable-users-138318.html

but the only options i get are:

View Profile, Edit Details, Delete Profile Picture, Set Password, Disable

No delete option.

The user has already logged in so this doesnt seem to work

https://confluence.atlassian.com/confkb/unable-to-delete-a-user-that-has-never-logged-in-200705535.html

I have tried this but the no joy (assuming its for jira not confluence)

https://confluence.atlassian.com/jirakb/delete-user-from-database-in-jira-server-733937809.html

but SQL throws an error Table 'confluence.app_user' doesn't exist

So I am unable to find either the correct SQL statements on how to remove the user, or even just being able to change the email address would be fine.

Many thanks in advance

W

[Daniel Eads · Accepted solution]

Hi Will,

Confluence's database doesn't have an equivalent table to Jira's app_user table. Only the cwd_* tables mentioned in that article are present in Confluence.

As you are looking to resolve the problem with duplicated email addresses in the migration assistant, I would advise changing the email address rather than deleting the user from the database. The records involved here are email_address and lower_email_address in the cwd_user table.

Standard warning: Confluence should be off when modifying the database, and you'll want to take a backup first if possible. If you are using a database client with a GUI, it might be convenient to simply modify those two records directly in your client and commit the changes to the database. Otherwise, you could use this SQL statement as a starting point, swapping in your <new_email> and <username>:

UPDATE cwd_user SET lower_email_address = '<new_email>', email_address = '<new_email>' WHERE user_name = '<username>'

Cheers,
Daniel | Atlassian Support

[Will Lear]

Absolutely nailed it, many thanks :-)