hi To All,

i want to do UnAuthorize User by Progamitically.

can any tell me it there any Fields in users,userProfile, aspnet_Users , aspnet_Membership etc... for UnAuthorize User??


Regards,
Hitesh Panchal

The column is isApproved from the aspnet_Membership table. The table is bound to the Users table of DNN by the username and ApplicationID. Provided below are two samples, one if you are unauthorizing the user by UserID the other if using the username. In both cases I assume you will only have one applicationID.

/* By UserID: */
UPDATE am
set am.isApproved = 1
from
aspnet_users au
join aspnet_membership am on
am.UserID = au.UserID
join users u on
au.Username = u.Username AND
u.UserID = @UserID

/* By Username: */
UPDATE am
set am.isApproved = 1
from
aspnet_users au
join aspnet_membership am on
am.UserID = au.UserID and
au.username = @Username