Re: Using xp_smtp_sendmail from a stored proc

From: Uri Dimant (urid_at_iscar.co.il)
Date: 05/24/05

  • Next message: msn_at_jrbrady.com: "Re: Ipsec & SQL Server" 
    Date: Tue, 24 May 2005 17:57:20 +0300

    Rudi
    Grant EXECUTE permission on the stored procedure that you wrote

    "Rudi" <rla.remove@finarch.com> wrote in message
    news:%23dYJG3GYFHA.2588@TK2MSFTNGP14.phx.gbl...
    > 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: msn_at_jrbrady.com: "Re: Ipsec & SQL Server"

    Relevant Pages

    • Re: Update statement performance decreases in stored proc
      ... Have you had a look at the execution plan of the stored procedure? ... Here are the important parts of the stored proc: ... I found that this was casued by the UPDATE statement at the end ...
      (microsoft.public.sqlserver.programming)
    • Re: RETURN_VALUES ??? done... What have I gained?
      ... b (aka whipper-snapper) ... > similar questions via stored proc and can set up a function to do the work ... >> tAdoDataSet is really easy to use. ... >> dataset even though you are pointing to a stored procedure. ...
      (borland.public.delphi.database.ado)
    • Re: RETURN_VALUES ??? done... What have I gained?
      ... Who is Doctor Codd? ... similar questions via stored proc and can set up a function to do the work ... > tAdoDataSet is really easy to use. ... > dataset even though you are pointing to a stored procedure. ...
      (borland.public.delphi.database.ado)
    • TableAdapter, INNER JOINs, stored procs, and problems with Update
      ... I have a stored procedure that uses JOINs to return columns from multiple ... I also have another stored proc that that takes a series of params ... @ac2 int, ...
      (microsoft.public.dotnet.framework.aspnet)
    • RE: Repost - Sql Server 2005 - SSIS - nbr of input cols < nbr stored proc parameters (MS
      ... proc parameters ... | file and insert them into an existing table using an 'insert stored proc' ... | inputs for all the stored proc parameters but the flat file only contains ... | and a stored procedure that inserts records into our lkp_county table ...
      (microsoft.public.sqlserver.dts)