How to find groups membership for a specific user in Confluence Data Center
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
要約
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.
環境
Confluence 7.19.5
ソリューション
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>';
最終更新日 2024 年 9 月 26 日
Powered by Confluence and Scroll Viewport.