开发者

how to add signature to a DDL trigger?

开发者 https://www.devze.com 2023-01-30 13:07 出处:网络
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

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

精彩评论

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