xp_sendmail error

[hne]

Hi DB gurus,
When I run the query to send an email,

EXEC master..xp_sendmail
@recipients = 'mcellery.badio@delta.com',
@subject = 'Mail sent'

I get the error:
Server: Msg 229, Level 14, State 5, Procedure xp_sendmail, Line 1
EXECUTE permission denied on object 'xp_sendmail', database 'master', owner 'dbo'.

HELP!!! How can I resolve this? Thanks!

 

[JohnBates]

hne,

You can make the user dbo, granting them the permissions that go along with database owner.

If that is not an option, grant the specific user 'execute' rights to the xp_sendmail object.

In Enterprise Manager, you do that by....
expanding Master database
click 'Users'
Right-click on the user name--> Properties
click Permissions
scroll down to 'xp_sendmail' and click on the Exec column

This will enable the user to run xp_sendmail

I hope this helps.
If you dont have Enterprise Manager, post back and we will
give you the syntax to do the same withing Query Analyzer.

John