Re: Using xp_smtp_sendmail from a stored proc

From: Support (RemoveThis_Support_at_mail.oci.state.ga.us)
Date: 05/25/05

  • Next message: Support: "selective object restrictions" 
    Date: Wed, 25 May 2005 11:06:01 -0400

    I had the same problem:
    make sure the db chainning permissions thing is turned on
    check sp_dboption
    Terry

    "Uri Dimant" <urid@iscar.co.il> wrote in message
    news:uuXZ47PYFHA.2520@TK2MSFTNGP09.phx.gbl...
    > Rudi
    > What is an error? Have you done dynamic sql inside your sp?
    >
    > "Rudi" <rla.remove@finarch.com> wrote in message
    > news:%23XVwgnPYFHA.1868@TK2MSFTNGP14.phx.gbl...
    >> That is what I have done, but I still get the error message in the
    >> application that the user needs execute permissions on the extended
    >> stored
    >> proc...
    >>
    >> could anyone point me to some links that explain this behaviour?
    >>
    >> Thanks
    >>
    >> "Uri Dimant" <urid@iscar.co.il> wrote in message
    >> news:OLuVJEHYFHA.712@TK2MSFTNGP14.phx.gbl...
    >> > 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: Support: "selective object restrictions"