我只需要一个用户通过会话同时登录 [英] I need only one user make login at the same time by session

问题描述

我已经按会话登录但我需要另一个人用同一个用户登录，DB自动退出



我尝试过：



如何让DB colum计算用户会话

im already make login by session but i need if another one make login with same user, DB make logout automatically

What I have tried:

how can i make DB colum to count user session

推荐答案

首先，这个是一种设计Web应用程序的糟糕方式。但是，如果必须这样做，那么您需要尽可能地在sql中跟踪SessionID，当其他人登录时设置一个标志以放弃其他会话或阻止登录，无论您需要做什么。

First off, this is a poor way to design a web application. However, if it must be done then you need to track SessionIDs in sql as best you can and when someone else logs in set a flag to abandon the other session or prevent login, whatever you need to do.

查看文章限制登录SQL Server [< a href =http://www.codeproject.com/Articles/1139017/Restricting-logon-to-SQL-Servertarget =_ blanktitle =New Window> ^ ]。

也许它会包含一些你可以使用的想法。

Have a look at article Restricting logon to SQL Server[^].
Perhaps it would contain some ideas you could use.

这篇关于我只需要一个用户通过会话同时登录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！