Check out this great series of articles on the details of ASP.Net membership, roles and profiles

http://aspnet.4guysfromrolla.com/articles/072308-1.aspx