>Some links on the topic:
>
>http://msdn2.microsoft.com/en-us/magazine/cc163457.aspx
>
>http://weblogs.asp.net/scottgu/archive/2006/01/10/435038.aspx
>
>http://weblogs.asp.net/scottgu/archive/2006/07/23/Recipe_3A00_-Implementing-Role-Based-Security-with-ASP.NET-using-Windows-Authentication-and-SQL-Server.aspx

Looks like somebody else had this problem before (I found this page after digging into 10+ links):

http://flimflan.com/blog/ProfileView.aspx (see comments to this page).