Posted on: 4/25/2011 11:36:13 PM | Views : 315

I'm trying to find out what the sql statement for finding out what users haven't been assigned a role.
I know that I have a user that I have basically turned off access to the two roles that I have set up.
My code so far:
SELECT aspnet_Membership.Email as eMail, aspnet_Roles.RoleName FROM aspnet_Membership CROSS JOIN aspnet_Roles where aspnet_Roles.RoleName = 'Admin' or aspnet_Roles.RoleName = 'Member'
What's the best way of finding out from all the users that I have available within my application i.e assigned roles?
 
I hope I'm making myself clear?
...

Go to the complete details ...