Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2009-10-01 : 07:54:48
|
| Hi,I am getting the following error when trying to send dbmail."The execute permission was denied on the object 'sp_send_dbmail' database 'msdb' schema 'dbo'."I have run the following scripts and have verified permissions and role membership.Any suggstions?EXEC msdb.dbo.sp_addrolemember @rolename = 'DatabaseMailUserRole' ,@membername = 'terry';Use msdbgoGrant EXEC on sp_send_dbmail to terryEXEC sp_helprotect 'sp_send_dbmail', 'terry'Thanks,Terry |
|
|
|
|
|
permission denied on sp_send_dbmail