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,
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.
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 :)
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:
Source documentation: Change a Username
I hope this clarifies how Jira and Confluence will handle user name changes.
- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...
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