Is there any database query to bulk update groups in project roles ?

[Avinash]

Hi,

I am looking to bulk update groups or replace groups in project roles in JIRA as we are moving to new groups in a new directory ? Should I use API instead ? 

Any help is appreciated. 

Thanks

Avi

[jndeverteuil · Accepted solution]

Hello,

I would use the API as their would be less chance that you break something. Generally speaking, I've learnt with colleagues to always use the API before touching the database.

You could make a script that iterate over a predefined set of project key and set the role in them using this API REST method:

• api/2/project/{projectIdOrKey}/role -- Set Actors

I hope this will help you achieving what you want!

If you think that have helped you, let me and the others know by indicating your question as answered :)

Cheers!

[Avinash]

@jndeverteuil Can you suggest me a way for Confluence Space permissions ?