motioneye
asked on
sp_send_dbmail says access is denied
I received and error message below:
Duration 00:00:00
Sql Severity 14
Sql Message ID 229
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: domain1\userA. The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229). The step failed.
But User domian1\userA has following privilled in msdb database, I even add him as db_owner but the same error message seems to be exist again and again
sp_send_dbmail ALTER
sp_send_dbmail CONTROL
sp_send_dbmail DELETE
sp_send_dbmail EXECUTE
sp_send_dbmail INSERT
sp_send_dbmail RECEIVE
sp_send_dbmail REFERENCES
sp_send_dbmail SELECT
sp_send_dbmail TAKE OWNERSHIP
sp_send_dbmail UPDATE
sp_send_dbmail VIEW CHANGE TRACKING
sp_send_dbmail VIEW DEFINITION
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.