如何为DDL触发器添加签名？
我在数据库上有一个 DDL 触发器。我想通过证书为其添加签名。我拥有完整的 sa 权限，但是当我尝试运行该语句时
ADD SIGNATURE TO OBJECT::[objects_monitoring]
BY CERTIFICATE [mail_certificate]
WITH PASSWORD = 'password1';
GO
，出现以下错误
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.
如何将签名添加到此 DDL 触发器？
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
根据此链接， DDL 触发器无法签名。
According to this link, DDL triggers cannot be signed.