自动添加权限触发器

USE [SINO]
GO

/****** Object:  DdlTrigger [TS_CREATE_TABLE]    Script Date: 11/11/2010 10:46:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [TS_CREATE_TABLE]
ON DATABASE
FOR CREATE_TABLE
AS
DECLARE @data XML,@t nvarchar(128),@s varchar(8000)
SET @data = EVENTDATA()
--select @data
set @t=@data.value('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(128)')
--print @t
if @t like 'par%'
begin

--print @t
set @s='GRANT SELECT ON ['+@t+'] TO [public] AS [dbo]
print ''表['+@t+']添加public查找权限成功！''
'
begin try
exec(@s)
end try
begin catch
print '表['+@t+']添加public查找权限失败！'
end catch
end

GO

SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO

DISABLE TRIGGER [TS_CREATE_TABLE] ON DATABASE
GO

ENABLE TRIGGER [TS_CREATE_TABLE] ON DATABASE
GO