Create Table User with fields (UserID Primary Key, UserName,Password),Roles(RoleID Primary Key,RoleName) and UserRoles(id Primary Key, UserID Foreigh Key,RoleID Foreign Key).Populate the above tables with data. You can authenticate users based on roles from now by simply configuring web.config file.