The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.

Hi..
I'm unable to send email. How can I give all users permissions?
I have tried the following

EXEC msdb.dbo.sp_addrolemember @rolename = 'DatabaseMailUserRole'
    ,@membername = '<user or role name>';
GO

But get

User does not have permission to perform this action.
LVL 1
JElsterAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you need to connect as server admin or security to perform the "grant" operation (adding role members is exactly a grant).
0
 
SThayaConnect With a Mentor Technical MAnagerCommented:
0
All Courses

From novice to tech pro — start learning today.