rudi

Hi,

I'd like to use the xp_smtp_sendmail extended stored procedure from a


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

uri dimant

Rudi


"Rudi" <rla.remove@finarch.com> wrote in message news:%23dYJG3GYFHA.2588@TK2MSFTNGP14.phx.gbl...

uri dimant

Rudi
What is an error? Have you done dynamic sql inside your sp?