How to find groups membership for a specific user in Confluence Data Center
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This document shows how to look up for the groups to which a user is member of, from a database perspective.
Check Adding or Removing Users in Groups if you want to add/remove users to existing groups.
Environment
Confluence 7.19.5
Solution
Please, run the following database query replacing the <username> with the actual name of your user within single quotes:
SELECT user_name, group_name FROM cwd_user u , cwd_group g , cwd_membership m
WHERE g.ID = m.parent_id AND u.ID = m.CHILD_USER_ID AND u.USER_NAME = '<user_name>';
Last modified on Sep 26, 2024
Powered by Confluence and Scroll Viewport.