Geraldo,

I believe there are some views and stored procs in the database .Net creates that may help you. Also, if this is from a web site, you may be able to make use of the CurrentUser object on the Request object. It has a method called IsInRole, I believe. Just depends on what you need.

HTH,
Chad



>Hi,
>
>With Select-SQL can I get data from ASPNet_Users and ASPNet_MemberShip like this example:
>
>

>Select ASPNet_Users.UserID, ASPNet_Users.UserName, ASPNet_MemberShip.Password, ASPNet_MemberShip.EMail
>from ASPNet_MemberShip inner join ASPNet_Users on ASPNet_Users.UserID = ASPNet_MemberShip.UserID
>

>
>But, in my case, I need to get data from ASPNet_Roles too like this:
>

>Select ASPNet_Users.UserID, ASPNet_Users.UserName, ASPNet_MemberShip.Password, ASPNet_MemberShip.EMail, ASPNet_Roles.RoleName
>from ASPNet_MemberShip inner join ASPNet_Users on ASPNet_Users.UserID = ASPNet_MemberShip.UserID
>  inner join ASPNet_UsersInRoles on ASPNet_UsersInRoles.UserID = ASPNet_Users.UserID
>  inner join ASPNet_Roles        on ASPNet_Roles.RoleID = ASPNet_UsersInRoles.RoleID
>

>
>
>Can you help me ?