USE ProductionData GOCREATE TRIGGER DDL____Event____Logger ON DATABASE FOR CREATE_FUNCTION, ALTER_FUNCTION, DROP_FUNCTION, CREATE_INDEX, ALTER_INDEX, DROP_INDEX, CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE, CREATE_TABLE, ALTER_TABLE, DROP_TABLE, CREATE_TRIGGER, ALTER_TRIGGER, DROP_TRIGGER, CREATE_VIEW, ALTER_VIEW, DROP_VIEW AS SET NOCOUNT ON
INSERT INTO [Log].dbo.EventLog ( Data ) VALUES ( EVENTDATA ) GO
USE ProductionData
GOCREATE TRIGGER DDL____Event____Logger
ON DATABASE
FOR
CREATE_FUNCTION, ALTER_FUNCTION, DROP_FUNCTION,
CREATE_INDEX, ALTER_INDEX, DROP_INDEX,
CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE,
CREATE_TABLE, ALTER_TABLE, DROP_TABLE,
CREATE_TRIGGER, ALTER_TRIGGER, DROP_TRIGGER,
CREATE_VIEW, ALTER_VIEW, DROP_VIEW
AS
SET NOCOUNT ON
INSERT INTO [Log].dbo.EventLog ( Data )
VALUES ( EVENTDATA )
GO
对log库有权限吗