Report user community role from a query?

Is there a simple way to report the users that have access to a community/role within the system? I don’t see this information stored within the database. Our support staff would like to reference a report like this when fulfilling support requests by looking up who is an approver/editor for a particular web page.

We do not use the Userlogin table.

Are you using the PSX_SUBJECTS table?

Thanks, that’s exactly what I needed.