27,582
社区成员




CREATE TRIGGER tr_Logon_CheckHostName
ON ALL SERVER
WITH EXECUTE AS 'Account'
FOR LOGON
AS
BEGIN
DECLARE @HostName NVARCHAR(50);
SET @HostName= host_name()
IF @HostName NOT IN ('xxxxxxxx','AAAAAAAA'.....)
BEGIN
ROLLBACK
END
END
IF EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'varchar(15)') <> 'IP'
AND ORIGINAL_LOGIN()= 'Account'
ROLLBACK
USE [master]
GO
DENY CONNECT SQL TO [test]
GO
ALTER LOGIN [test] DISABLE
GO