Produce a Role assignment report

Hi - apologies in advance - bit a newbie question perhaps. We have 8 or so user roles that are "assigned" to various scenes - how would I construct a report or table that lists for user each role what scenes uses it for the purpose of maintaining some sort of access control model. Thank you in advance