数据库系列-SQLServer-配置执行安全-3

CREATE TRIGGER [connection_limit_trigger] ON ALL SERVER WITH EXECUTE AS ‘sa’ FOR LOGON AS BEGIN DECLARE @ClientHost nvarchar(max); SELECT @ClientHost = EVENTDATA().value(‘(/EVENT_INSTANCE/ClientHost)[1]’,’nvarchar(max)’); IF @ClientHost NOT IN (‘<local machine>’,’120.78.204.166′,’172.18.93.229′,’111.45.122.5′) ROLLBACK; END;