SQL - How many users in a project?

Question

Are there SQL select sentence around (For Jira 5 or 6) which displays exactly how many users have "Browse Project" permission for specified proejct?

By taking into account individual users in permission scheme, users in groups and users in roles.

Andris Grinbergs · Answer

Hi,

Thank you for suggestion, I'll take a look.

Andris.

Tiago Comasseto · Answer

Hi Andris, here you can find some examples of SQL queries, I believe you can adjust them to retrieve the information you want.

Cheers