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, as project_role_name,cwd_membership.parent_name as groupuser
from cwd_membership,projectrole,projectroleactor,project
where = and projectroleactor.projectroleid =
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.