Email address change for all users in Confluence

I want to change all confluence users email address from our old company name to new company name?


Is there a way we can replace each users email with the new email address and have that account maintain their documents and content?

2 answers

0 votes

It depends on what type of user directory you are using and your username format.

Is it the internal Confluence directory?  Is the user name format a simple "login" and not their email (e.g. when logging in, I'd enter "nic" in the username box, not "")

We currently use Confluence Internal Directory and are using login ids (bthomas) to login via OKTA 

Ok, that keeps it more simple.   I assume your Okta is the usual usage - it's effectively a password safe, rather than an authenticator?

Correct they gain access by login in to OKTA and click on icon to gain access.  

Ok, good.  There's several ways to do this, but it's better to look at what needs doing before talking methods.

The change you need to make is relatively simple. There is a table in the database called cwd_user.  This holds (amongst other stuff), the login id, the data that connects a user to a thing in Jira, and an email address.  As you only want to change the email address, there's no problem with losing connections to other things - the email has nothing to do with how users are linked to pages/spaces/permissions/etc

I would personally do it the safer way - whack in script runner and write a little bit of one-off code to go through the user directory and replace addresses as appropriate.

But SQL is probably quicker and cheaper.   If, for example, you have an email format of and the update is as simple as changing it to, then a simple search and replace through the two email columns will do it.  Make sure Confluence is offline before doing this otherwise it might cache some of the old emails.

Great info and thanks for your help. 

@Bryan Thomas have you checked that the users email address is does not update when the user logs into the application?


With our Single Sign-on add-on attributes are updated automatically when the user logs in.


The user mark.miller has an email address in JIRA and in Okta. 

His email address is then changed to in Okta.

The next time he logs into JIRA his email address is automatically changed to

A requirement for this is (obviously) that the email address is sent as a attribute statement (Name: email, Value 



Lars, Kantega Single Sign-on

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,591 views 4 13
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you