Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

delete local confluence user

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

1 answer

1 accepted

0 votes
Answer accepted
Daniel Eads Atlassian Team Feb 09, 2021

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

Absolutely nailed it, many thanks :-)

Like Daniel Eads likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Confluence

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

156 views 0 5
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