March 17, 2003 at 3:14 pm
Is there any way in SQL Server to disconnect user after specified time. I want to disconnect user who are not using system for more than 15 minutes. This is some kind of security I like to provide for my district.
Let's say user login into system and then he/she leave the system and some other person will come and uses his/her system. We can put the time at the front-end but I don't want to change the front-end code because that is not under my control.
appreciated if you could help me
March 17, 2003 at 3:27 pm
Write a procedure to disconnect people when the sysprocesses.lastbatch is over 15 minutes.
Schedule this to run every xx minutes.
Steve Jones
March 19, 2003 at 12:53 pm
Thanks Steve, I created Stored procedure to kill users based on last_batch field.
do you have any idea about Dashboard technology, our district wanted to implement this new technology. I have no idea about this technology.
March 19, 2003 at 2:29 pm
Balbir,
You might also want to check the status of the job, of its sleeping or runnable. Otherwise you might endup killing a job, which is running for long time.
Are you talking about Dashboard Application or Dashboard Technology?!
Regards,
Murali Damera.
.
March 20, 2003 at 9:39 am
Thanks for your update on the issue. I will do that.
Yes, I am talking about both application and technology. I was told to implement Dashboard technology. I have no idea about that.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply