Is there an equivalent to app_user table in Confluence ?

[Eddy_Fras]

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

[Stephen Sifers]

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:

• How to identify inactive users in Confluence
• Confluence Data Model

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

Regards,
Stephen Sifers

[Eddy_Fras]

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

[Stephen Sifers]

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