Method to list all users that hav individual granted permissions?

[Thomas]

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

[Thomas]

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)]

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

[Per Löfgren (Qlik)]

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