开发者

how to add signature to a DDL trigger?

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?


According to this link, DDL triggers cannot be signed.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜