Using xp_smtp_sendmail from a stored proc

From: Rudi (rla.remove_at_finarch.com)
Date: 05/24/05

  • Next message: Uri Dimant: "Re: Using xp_smtp_sendmail from a stored proc" 
    Date: Tue, 24 May 2005 16:35:01 +0200

    Hi,

    I'd like to use the xp_smtp_sendmail extended stored procedure from a
    procedure I wrote.
    The normal procedure is installed as dbo on the database, but I still need
    to grant execute rights to the end-users (using integrated security... its
    legacy) for the extended stored procedure.

    Of course, I'd rather not have to do that, as it exposes to my sql server
    (mail spamming, files can be fetched from the server..).

    How can I set-up the security (or the stored proc) so that I do not need to
    grant users the execute right on the extended stored proc.
    (reminder: connection is made using integrated security)

    Thanks
    Rudi

  • Next message: Uri Dimant: "Re: Using xp_smtp_sendmail from a stored proc"