Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: How to allow use to exec xp_sendmail

    I have a stored proc that assigns a value to a field based on user input from an Access front end.

    The last part of the stored proc sends an email if certain conditions are met.

    It appears that users do not have permission to execute xp_sendmail. I guess this is because it is executed on the master database. Is there a way I can give them permission to this stored proc?

    The users are getting this message:

    EXECUTE permission denied on bject 'xp_sendmail', 'database master', owner 'dbo'.(#229)

  2. #2
    Join Date
    Sep 2003
    Dallas, Texas
    You can grant a user to execute xp_sendmail by going to properties of xp_sendmail in master database and grant the user permission to execute.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts