Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

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
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial