使用DDL触发器限制访问的来源

use master

Go

Create TRIGGER Login_Check_Trigger
ON ALL SERVER
FOR logon
AS
BEGIN
DECLARE @ClientHost nvarchar(max);
SELECT @ClientHost = EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]','nvarchar(max)');
IF (left(@ClientHost,10)<> '192.168.18' or @ClientHost<>'<local machine>')--指定网段或本机
BEGIN
ROLLBACK TRAN;
END
END

Go

转载于:https://blog.51cto.com/imdbt/986498