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.
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.