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

[sanjay]

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 

[Ivan Lima]

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.

[sanjay]

Hi @Ivan Lima 

Thanks for the guidance I will check on it 

Regards,

Sanjay