How can I kick the user if I change IsConfirmed column?

Question

I use ASP.NET SimpleMembership..

My scenario;

The user login and then I change IsConfirmed column to false on webpages_Membership table.. And the user try to change page, the login page seems to the user..

Answer 1

I user Application_AuthenticateRequest in Global.asax.. Because my application needs authenticate on all pages..

protected void Application_AuthenticateRequest()
        {
            if (WebSecurity.IsAuthenticated)
            {
                bool isConfirmed = (..your codes here..)
                if (isConfirmed == false)
                {
                    WebSecurity.Logout();    
                } 
            }
        }