Want to know that jira projects linked to groups or users

[Varsha Gupta]

Hello,

i want a query for checking the jira projects in which groups are added or individual users are added or how to check permission of jira projects from database

Regards

Varsha gupta

[Petter Gonçalves]

Hello Varsha,

Welcome to Atlassian community!

Could you please let us know what is the JIRA Server version you are currently using? Or you are using JIRA Cloud?

I understand that you would like a database query to return which users/groups/roles are added to which projects permissions. Is that correct?

This information can be achieved by the query below in almost every JIRA Server version:

select distinct p.pname, r.ROLETYPEPARAMETER, rr.NAME, s.PERMISSION_KEY 
from projectroleactor r 
left outer join projectrole rr on rr.id = r.projectroleID
inner join schemepermissions s on s.perm_parameter = r.roletypeparameter 
inner join project p on p.id = r.pid
order by p.pname, rr.NAME, r.ROLETYPEPARAMETER, s.PERMISSION_KEY; 

For more information, you can check the documentation below:

- How to get a list of permissions granted to users and/or groups assigned to Project Roles

Now, if you are using JIRA Cloud, I'm afraid database access is a restricted function on Cloud as you can see in this documentation:

- Functional differences in Atlassian Cloud

Let me know if this information helps and have a nice Tuesday! :)