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

Is there an equivalent to app_user table in Confluence ?

Hi all,

Considering this post (https://community.atlassian.com/t5/Jira-questions/What-about-the-data-in-app-user-table/qaq-p/787427), I'd like to understand how Confluence 6.13 does to manage user name updates.

I didn't find an "app_user" table in DB but is there an equivalent table that stores the user name at first login, use it for all user reference and store the current user name ?

Or is the "user_mapping" table with its "user_key" column used to identify uniquely each user for actions on pages or spaces ?

Thanks for your help,

Eddy

1 answer

0 votes

Hello Eddy,

Thanks for reaching out and reviewing a similar post you’re wanting to adapt for Confluence. If you’re looking for the username at login then the cwd_user table with column user_name would be the best location to find that. If you’re needing user information then user_mapping would contain more information. There are additional resources to review for examples and to see what is stored where at:

I hope this information proves helpful for finding what you’re looking for.

Regards,
Stephen Sifers

Hello Stephen,

Thanks a lot for your answer.

I already read the docs in the links you provided but I don't understand what's happening when a user is renamed.

In Jira, the app_user table keeps a mapping between first login used and its current user name.

But how does it work in Confluence when it's using the remote Jira users directory ?

Let's imagine we add a user ABC in Jira directory. It creates some content and then we rename it into DEF.

If I understood well, all content created by this user is identified as owned by ABC, even after rename and the app_user table is used to know what is the current user name of user ABC.

But if this user created content in Confluence before renaming, this content is identified as owned by ABC. Then the rename occurs, Confluence directory is synchronized with Jira's one. So how does Confluence know that the user named now DEF has created the content when he was ABC ?

Sorry, I'm not sure I'm very clear, hope you'll understand what I mean :)

Eddy

Hello Eddy,

Thank you for the response and additional clarification in your question. If you’re using Jira 6.1 or later and update a user then it should be reflected in Confluence. If the user created/edited content, then the user name was changed, Confluence will sync with Jira and detect this change update any mention of the user.

There are some things to be noted here, as follows:

  • Mentions and page history – Any user mentions in current pages will automatically reflect the user's new username, but any mentions in page versions created prior to Confluence 5.3 will include the user's old username. 
  • Personal Spaces – If a Confluence Administrator renames a user who has a personal space, the space key for that space will remain as the original username. For example, if jsmith's username is changed to jbrown, their personal space key will remain ~jsmith.

Source documentation: Change a Username

I hope this clarifies how Jira and Confluence will handle user name changes.

Regards,
Stephen Sifers

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

327 views 9 7
Join discussion

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