How to identify which Groups have access to a Project in JIRA

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

You may run the following SQL query to find out the Users/Groups associated with Project Roles in a Project. I have modified the query to see which Groups are assigned to a Project role to which Project.

Finding which Groups have access to a Project - Run on JIRA DB
select project.pkey as pkey,project.pname as project_name,projectrole.name as project_role_name,cwd_membership.parent_name as groupuser
from cwd_membership,projectrole,projectroleactor,project
where project.id = projectroleactor.pid and projectroleactor.projectroleid = projectrole.id
and roletype = 'atlassian-group-role-actor' and membership_type='GROUP_USER' and parent_name=roletypeparameter
group by pkey,project_name,project_role_name,groupuser;

The above SQL query only works on Postgres database, you may need to rewrite it accordingly to suit for other supported database.

Last modified on Mar 31, 2017

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.