如何在三天内阻止用户登录 [英] How to block user login with in three days

问题描述

大家早上好，



我想阻止用户登录。假设他没有登录三天。自动用户凭据被拒绝。



提前谢谢

hi Good morning every one,

i want to block user login. suppose he was not logged in for three days . automatically user credentials got denied.

thankq in advance

推荐答案

有一张记录上次成功的表用户登录（或者每次登录，如果你愿意，那么只需要根据需要查询最后一次登录）。



登录后，检查此表（除了他们的用户/密码）如果上次登录超过3天，则拒绝他们访问。

Have a table that records the last successful user login (or every login if you like, then just query the last login as required).

Upon logging in, check this table (in addition to their user/password) and if the last login was more than 3 days ago, deny them access.

http://sqlsalt.blogspot.in/2012/03/limit-instance-access-by-time-and-day.html [< a href =http://sqlsalt.blogspot.in/2012/03/limit-instance-access-by-time-and-day.htmltarget =_ blanktitle =New Window> ^ ]



http://blogs.technet.com/b/vipulshah/archive/2007/12/04/ddl-triggers-and-logon-triggers.aspx [ ^ ]



http://sqlblogcasts.com/blogs/simons/archive/2010/12/03/restricting-logons-during-certain-hours-for-certain-users.aspx [ ^ ]



查看此链接..希望你能得到一个想法......

http://sqlsalt.blogspot.in/2012/03/limit-instance-access-by-time-and-day.html[^]

http://blogs.technet.com/b/vipulshah/archive/2007/12/04/ddl-triggers-and-logon-triggers.aspx[^]

http://sqlblogcasts.com/blogs/simons/archive/2010/12/03/restricting-logons-during-certain-hours-for-certain-users.aspx[^]

check this links..hope u will get an idea...

这篇关于如何在三天内阻止用户登录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！