log out asp.net user through sql?

Question

Can I force a log out through SQL for asp.net membership account?

I added 'forms-authentication' tag since it was stated that was the auth mode in a comment below. — ddc0660, Dec 16 '09 at 16:08

score 1 · Answer 1 · edited May 23 '17 at 10:24

1

For forms authentication you can use:

FormsAuthentication.SignOut();
FormsAuthentication.RedirectToLoginPage();

If you are trying to do this through Windows authentication see this.

edited May 23 '17 at 10:24

Community

1
1

answered Dec 15 '09 at 18:50

David Glass

2,304
1
25
35

I specifically asked for SQL. – TPR Dec 15 '09 at 20:23
1

Not sure I understand than, what do you mean through SQL. What Authentication are you using? Forms, Windows, or Passport? – David Glass Dec 15 '09 at 20:42
I am using Forms Authentication. But I am trying to log someone out inside of my SQL code, but that seems impossible. – TPR Dec 15 '09 at 22:03

ddc0660 · Accepted Answer · 2009-12-16T16:07:04.437

No record of currently logged in users are stored in Forms Authentication mode so it would be impossible to log out a user by some SQL execution alone.

Note that a data store like SQL is only used during the actual credential authentication step of the Forms Authentication lifetime:

Forms authentication control flow http://i.msdn.microsoft.com/Aa480476.formsauth(en-us,MSDN.10).gif

Forms Authentication generally utilizes client-side cookies to handle currently logged in users.

Source: Explained: Forms Authentication in ASP.NET 2.0

log out asp.net user through sql?

2 Answers2

Linked