阻止用户（除SA用户）删除数据库表

/****** 对象:  DdlTrigger [TR_Safety_Table]    脚本日期: 06/07/2011 14:20:06 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: <,>

-- Create date: <2010-04-03>

-- Description: <除了sa用户，禁止其他数据库用户 ALTER TABLE 和DROP TABLE的权限>

-- =============================================

CREATE TRIGGER [TR_Safety_Table]  

ON DATABASE  

FOR DROP_TABLE, ALTER_TABLE

AS  

IF( ( SUSER_SNAME() <>'sa' )and (SUSER_SNAME() <>'登录用户名') )

  BEGIN

  PRINT '你无DROP TABLE 和 ALTER TABLE 的权限！'  

  ROLLBACK

END

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

ENABLE TRIGGER [TR_Safety_Table] ON DATABASE