how to add signature to a DDL trigger?

Question

I have a DDL trigger on a database. I want to add a signature to it, by certificate. I have full sa rights, but when I try to run the statement

ADD SIGNATURE TO OBJECT::[objects_monitoring]
BY CERTIFICATE [mail_certificate] 
WITH PASSWORD = 'password1';
GO

I get the following error

Msg 15151, Level 16, State 1, Line 2
Cannot alter the object 'objects_monitoring', because it does not exist or you do not have permission.

How do I go about adding the signature to this DDL trigger?

I suspect that you need to use a different module_class than `OBJECT`, but there's not a great deal of documentation around on what other module_class values are supported. — Damien_The_Unbeliever, Dec 15 '10 at 15:40

score 3 · Accepted Answer · answered Dec 15 '10 at 15:45

3

According to this link, DDL triggers cannot be signed.

answered Dec 15 '10 at 15:45

Joe Stefanelli

1 Answers1