RDS instance send DAtabase Mail

Question

following error still occurred when a stored procedure tried to send Database email.This is an RDS instance

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

---

Kiran

Answer 1

You have to grant permissions for the used Login, see sp_send_dbmail (Transact-SQL)

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

which login?

---

Kiran

Answer 3

That one that runs the stored procedure, which sends the DB mail.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 4

Cannot find the object 'sp_send_dbmail', because it does not exist or you do not have permission

---

Kiran

Answer 5

Please note that it is an RDS instance

---

Kiran

Answer 6

If there is any thing RDS-specific here, you will need to ask in a forum devoted to RDS.

But apart from that, only posting an error message without telling us what you did, is not the best way to get help with your problem. But my guess is that you were not in msdb when you ran the GRANT command.

---

Erland Sommarskog, SQL Server MVP, [e-mail]