query to fetch individual users added in project permission in jira

Varsha Gupta August 1, 2019

Find the permissions of jira projects in which individual users added manually not added through groups

3 answers

0 votes
Roman Kersky
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 5, 2019
select pr.pname, pr.pkey, sp.PERMISSION_KEY, sp.perm_parameter from project pr
LEFT JOIN nodeassociation n ON n.SOURCE_NODE_ID = pr.id and n.SINK_NODE_ENTITY = 'PermissionScheme'
JOIN permissionscheme p on n.SINK_NODE_ID = p.id
jOIN schemepermissions sp on sp.SCHEME = p.ID
where perm_type in ('user', 'group')

HI. 

0 votes
Varsha Gupta August 3, 2019

Hello ,

 

I want list of all projects of jira with the individual added in particular project.

e.g

project name| key|permission|name of user or group|

0 votes
Roman Kersky
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 1, 2019

HI . You can use this SQL query

 

SELECT PS.name AS PermissionSchemeName,SP.perm_parameter AS GroupName, SP.permission_key AS Permission

FROM schemepermissions SP

INNER JOIN permissionscheme PS ON SP.scheme = PS.id

where perm_type = 'user'

Varsha Gupta August 1, 2019

Not Working

Roman Kersky
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 1, 2019

any details?      My result *(          image.png

Suggest an answer

Log in or Sign up to answer