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
想使用这样的方法来限制帐号Account在某几台机器上登录
请问这样做可以么?求高手指教