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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Source documentation: Change a Username
I hope this clarifies how Jira and Confluence will handle user name changes.
Regards,
Stephen Sifers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.