Assigning a group to a role in multiple projects

[Mark Everest]

There is a piece of functionality missing in Jira to be able to add a group to a role in multiple projects at once.

This can be done one project at a time, but we have 300 projects. This can be done for users, but not groups.

Does anyone know what tables are used to store group membership of project roles? At least if I can add them at the database level this will save me having to edit all these groups one at a time!

[Craig Castle-Mead]

Hi Mark,

If your underlying business need is "consistent group access across ~ 300 projects" - my suggestion would be using a permission scheme for this set of projects and granting the group access at the permission scheme level. 

While Sreenivasaraju's SQL looks correct, doing any writes directly in the DB is dangerous - so API based looping might be a better approach if it does need to be groups in roles.

CCM

[Mark Everest]

Hi,

Ah right - so you are suggesting using groups in a permissions scheme, rather than roles - that does make sense.

Thanks

Mark

[Craig Castle-Mead]

Yup yup!

:)

CCM

[Sreenivasaraju P]

Project role data gets stored in projectroleactor table.  Please check , you can update through sql commands

PID and PROJECTROLEID can get from Project and projectrole tables

sample query :

INSERT INTO projectroleactor(ID,PID,PROJECTROLEID,ROLETYPE,ROLETYPEPARAMETER) VALUES (XYZ,xxxx,yyyy,'atlassian-group-role-actor','jira-users');

XYZ- is sequence id

xxxx- project ID

YYYY - Project role ID

or 

you can try https://marketplace.atlassian.com/apps/6398/jira-command-line-interface-cli 

this should help.