Can we get the details of project roles assign to user using database query?

Question

I am interested to get all roles the user has in Jira Software. Is it possible ? please help me.

My Jira Software version : 8.5.6

Postgres Database Version: 10.5

Thanks In Advance

sanjay_haxsn9 · Answer

Hi @Ivan Lima

Thanks for the guidance I will check on it

Regards,

Sanjay

Ivan Lima · Answer

Hi @sanjay, have a look at the following jirakb: Retrieve a list of users assigned to project roles in Jira server. It should help you with that.

Cheers,

IL.