I was recently doing some testing of a script I created for a client which used SQL Database Mail for sending emails. this was on my one of my demo environments, but I received an error when testing the script:
Microsoft Dynamics GP
Unhandled database exception:
[Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.
The solution I found was to grant permissions to public, which did work, but I’m not convinced this would be an approach to take on a clients live system:
GRANT EXECUTE on sp_send_dbmail TO public