How to find groups membership for a specific user in Confluence Data Center
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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:
1
2
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>';Was this helpful?