While using asp.net membership and roles you will see two seperate entries for same user in aspnet_Users table. But you will have a single entry for that user in aspnet_Membership table. The reason for that is you have set applicationName for your membership...