CREATE TRIGGER [tr_connection_limit]
ON ALL SERVER WITH EXECUTE AS 'sa'
FOR LOGON
AS
BEGIN
--限制帐号的连接
IF ORIGINAL_LOGIN()= 'text'
--允许在本机和下面的IP登录
AND
(SELECT EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'NVARCHAR(15)'))
NOT IN('<local machine>','127.0.0.1')
ROLLBACK;
END;
SQL SERVER 通过触发器限制账户的登录IP
最新推荐文章于 2022-10-13 14:01:49 发布