How to Determine which Projects in JIRA have Anonymous Access Enabled

Still need help?

The Atlassian Community is here for you.

Ask the community

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

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.