Saturday, September 14, 2013

LogOn Trigger

USE master
GO

drop trigger trgRestrictUser2

CREATE TRIGGER trgRestrictUser3
ON ALL SERVER WITH EXECUTE AS 'Test'
FOR LOGON
AS
BEGIN
IF (ORIGINAL_LOGIN()= 'Test' AND
-- APP_NAME() = 'Microsoft SQL Server Management Studio - Query')
(select getdate())>='2013-05-12 16:10:22.097')
ROLLBACK;
END;

select getdate()
SELECT CURRENT_TIMESTAMP
SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]


http://sqlandme.com/2011/07/13/sql-server-login-auditing-using-logon-triggers/

No comments:

Post a Comment