Restricting logons during certain hours for certain users

Posted by simonsabin on SQL Blogcasts See other posts from SQL Blogcasts or by simonsabin
Published on Fri, 03 Dec 2010 22:17:28 GMT Indexed on 2010/12/06 16:58 UTC
Read the original article Hit count: 450

Following a an email in a DL I decided to look at implementing a logon restriction system to prevent users from logging on at certain ties of the day. The poster had a solution but wanted to add auditing. I immediately thought of the My post on logging messages during a transaction because I new that part of the logon trigger functionality is that you rollback the connection. I therefore assumed you had to do the logging like I talk about in that post (otherwise the logging wouldn’t persist beyond...(read more)

© SQL Blogcasts or respective owner

Related posts about SQL Server 2005

Related posts about security