Assigning a group to a role in multiple projects

Question

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_20fp9z · Answer

Yup yup!

:)

CCM

Mark Everest_qpl0l2 · Answer

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_20fp9z · Answer

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