且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何为其他数据库中的登录名授予对SQL Server数据库邮件过程的访问权限?

更新时间:2021-10-11 16:06:33

您可以使用EXECUTE AS并对过程进行签名,然后使用签名证书在 msdb $ c $中授予EXECUTE权限。 c>。请参阅调用过程,以及使用证书签署程序

You can use EXECUTE AS and sign your procedure and then use the signature certificate to grant EXECUTE permission in msdb. See Call a procedure in another database from an activated procedure, as well as Signing Procedures with Certificates.