I need to list all the users in our system with a combination of roles assigned to them.
User1 = Role1 + Role2 + Role8
User2 = Role1+ Role3 + Role8
User3 = Role1 + Role4 + Role8
I want to extract a listing of users with Role1 and Role8 assigned to them.
How do I go about doing this??