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

Still need help?

The Atlassian Community is here for you.

Ask the community

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

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.