Re: Using xp_smtp_sendmail from a stored proc

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

Date: Wed, 25 May 2005 09:17:53 +0200

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
>>
>>
>
>

Relevant Pages

  • Re: sql2k5 security
    ... you could give a user only Execute permissions on a ... stored procedure and the stored procedure could perform operations fine. ... Create a Schema named mySchema in the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Sql Server - Basic Permissions Question
    ... I have set EXECUTE permissions to the sp's as needed for the user. ... durring the execution of the stored procedure so long as the owner of the ... target table is the same as the owner of the stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: Permissions granting
    ... Users have EXECUTE permissions any user created stored procedure and ... I assume users cannot issue ALTER statements (e.g. ALTER ... Users should not be able to issue DDL commands ...
    (microsoft.public.sqlserver.dts)
  • Re: Stored Procedure and Table permissions
    ... execute permissions on the stored procedure. ... >given the user EXEC permission for the stored procedure. ...
    (microsoft.public.sqlserver.security)