Method to list all users that hav individual granted permissions?

Question

Is there a way to list all users that got individual granted permissions to spaces in confluence?

We only want user permissions via groups. So we need to find all individual granted permissions.

Thank you in advance

Per Löfgren (Qlik) · Answer

Just remove the "WHERE s.spacekey = '<SPACEKEY>" and it will list everything

Thomas · Answer

Hey Per,
thank you! Is it also possible to get permissions for the whole Confluence instance (not only for a single space)?

Thank you in advance

Per Löfgren (Qlik) · Answer

If you have access to the database you can run the query described here.

https://confluence.atlassian.com/confkb/how-to-check-permissions-for-a-space-via-sql-queries-717062216.html