How to Determine which Projects in JIRA have Anonymous Access Enabled
To determine which projects in JIRA have enabled anonymous access, please run the following query on the database:
select distinct(P.pname)
from nodeassociation NA
join project P on NA.source_node_id = P.id
join permissionscheme PS on NA.sink_node_id = PS.id
join schemepermissions SP on PS.id = SP.scheme
where NA.sink_node_entity = 'PermissionScheme'
AND NA.source_node_entity = 'Project'
AND SP.perm_type = 'group'
AND SP.perm_parameter IS NULL
AND SP.permission_key = 'BROWSE_PROJECTS';
Last modified on May 31, 2022
Powered by Confluence and Scroll Viewport.