(DIR) Return Create A Forum - Home --------------------------------------------------------- ExcelSoft Database Professionals (HTM) https://esdbp.createaforum.com --------------------------------------------------------- ***************************************************** (DIR) Return to: Scripts ***************************************************** #Post#: 116-------------------------------------------------- Limit user login time connection during business hours for a us er By: srinivasma_exceldbp Date: December 16, 2014, 9:44 pm --------------------------------------------------------- /* Limit user login time connection during business hours for a user(example: testuser1) ie “between 10:00 and 18:00 hours */ USE [master] GO --Create the login on your servel called "testuser1" CREATE LOGIN [testuser1] WITH PASSWORD=N'StrongPassword' ,DEFAULT_DATABASE=[master] ,DEFAULT_LANGUAGE=[us_english] ,CHECK_EXPIRATION=OFF ,CHECK_POLICY=OFF GO USE [master] GO CREATE TRIGGER [connection_limit_trigger] ON ALL SERVER FOR LOGON AS BEGIN DECLARE @ErrorText [varchar](128) SET @ErrorText = 'Cannot allow login to "testuser1" outside of normal business hours. ' SET @ErrorText = @ErrorText + 'Please try again between business hours 10:00 and 18:00.' IF ORIGINAL_LOGIN() = 'testuser1' AND (DATEPART(HOUR, GETDATE()) < 10 OR DATEPART (HOUR, GETDATE()) > 18) BEGIN PRINT @ErrorText ROLLBACK; END END; GO ENABLE TRIGGER [connection_limit_trigger] ON ALL SERVER GO execute as login = 'testuser1' *****************************************************