Re: Using xp_smtp_sendmail from a stored proc

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

  • Next message: madrianr: "Cannot change service account through EM (error from xp_setsqlsecu" 
    Date: Wed, 25 May 2005 10:53:23 +0300

    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: madrianr: "Cannot change service account through EM (error from xp_setsqlsecu"

    Relevant Pages

    • Re: How to execute from remote NFS?
      ... > That is not the error message I would have expected. ... > Maybe you have configured binfmt-misc to automatically ... > execute permissions to the wine executable on the client ... user flag turns on noexec. ...
      (comp.os.linux.development.system)
    • RE: The object invoked has disconnected from its clients.
      ... The latest server Usage Report email only contained this error message. ... It is recommended that you contact Microsoft Customer ... Support Services via telephone so that a dedicated Support ... Professional can assist you recover the server in a more efficient manner. ...
      (microsoft.public.windows.server.sbs)
    • Re: startx fails
      ... Subject: startx fails ... Have you looked in the paths shown in the error message? ... configure the netscape http server. ... install, or one on which people have done lots of patches? ...
      (comp.unix.sco.misc)
    • Re: Publishing WebForms to Production System
      ... Its already Off but same error message. ... <!-- CUSTOM ERROR MESSAGES ... Set trace enabled="true" to enable application trace logging. ... > and upload the modified web.config file to your server. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Publishing WebForms to Production System
      ... Its already Off but same error message. ... <!-- CUSTOM ERROR MESSAGES ... Set trace enabled="true" to enable application trace logging. ... > and upload the modified web.config file to your server. ...
      (microsoft.public.dotnet.framework.aspnet)