数据库触发器，禁止DDL操作

最新推荐文章于 2024-05-11 14:48:10 发布

weixin_34124577

最新推荐文章于 2024-05-11 14:48:10 发布

阅读量539

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/zping/p/5139174.html

版权

CREATE TRIGGER [Object_Change_Trigger_DDL] ON DATABASE
FOR ALTER_TABLE,DROP_TABLE,CREATE_TABLE,CREATE_INDEX,ALTER_INDEX, DROP_INDEX  
AS
DECLARE @EventData AS XML;
SELECT @EventData = EVENTDATA();
IF @EventData.value('(/EVENT_INSTANCE/LoginName)[1]','varchar(150)') NOT IN (
'uws_M_ApricotMDM_dev'
,'Us_wangdan_temp'
,'NT AUTHORITY\SYSTEM'
,'NT SERVICE\MSSQLSERVER'
,'WIN-6RNHUPNK4OJ\Administrator'
,'NT SERVICE\SQLSERVERAGENT'
,'bl_un'
) 
  BEGIN
   --RAISERROR ('创建，修改，删除表的权限已收回，如有问题请联系DBA!', 16, 1)     
   ROLLBACK
  END


GO

ENABLE TRIGGER [Object_Change_Trigger_DDL] ON DATABASE
GO