Who has project administration access on confluence and jira

Are you wondering who has project admin access on your JIRA or Confluence and you got something else to do then spending your afternoon clicking through all the permission schemes, and ‘Users and Roles’ screens ?

 

Here are 2 simple SQL queries which extract the list of users with this type of god power.

 

 

Extract all users who have project administration access on JIRA

 

SELECT distinct cu.display_name , cu.email_address
FROM dbo.schemepermissions sp
inner join cwd_membership cm on cm.lower_parent_name = sp.perm_parameter
inner join cwd_user cu on cm.lower_child_name = cu.lower_user_name
where sp.PERMISSION_KEY = 'ADMINISTER_PROJECTS'
and cu.active = 1
union
SELECT distinct cu.display_name
, cu.email_address
FROM dbo.schemepermissions sp
inner join cwd_user cu on cu.lower_user_name = sp.perm_parameter
where sp.PERMISSION_KEY = 'ADMINISTER_PROJECTS'
and cu.active = 1

Extract all users who have space administration access on confluence

 

 

SELECT sp.SPACENAME, cu.lower_display_name,cu.lower_email_address
FROM SPACES sp
JOIN SPACEPERMISSIONS pm ON sp.SPACEID = pm.SPACEID
JOIN user_mapping um ON pm.PERMUSERNAME = um.user_key
JOIN confluencedb.dbo.cwd_user cu on um.lower_username = cu.lower_user_name
WHERE pm.PERMTYPE = 'SETSPACEPERMISSIONS'
AND sp.SPACETYPE = 'global'
ORDER BY sp.SPACEKEY

 

 

 


Are you still using multiple issue trackers?

Check out exalate http://www.exalate.com – Exalate is an advanced issue synchronization solution which supports cross organization issue tracking.
Its flexibility comes from the built in groovy scripting capability allowing to implement almost any type of integration.

Support anyone ?

You can always contact us to help out with the implementation of your use cases, just contact us.

Leave a Reply

Your email address will not be published. Required fields are marked *