October 16, 2006 at 2:40 am
Halo, must I be sysadmin to send emails with attachments file with xp_sendmail. Have someone a permission workaround without to crate a new sp wich will call xp_senmail.
I found this i n BOL:
xp_sendmail runs in the security context of SQL Server. A valid user of xp_sendmail can access files for attachment to a mail message in an administrator's security context. If users other than system administrators must access xp_sendmail and you want to guard against unsecured access to attachment files, the system administrator can create a stored procedure that calls xp_sendmail and provides the needed functionality, but which does not expose the attachments parameter. This stored procedure must be defined in the master database. The system administrator then grants execute permission on the stored procedure to the necessary users without granting permission to the underlying xp_sendmail procedure.
/Semko
October 17, 2006 at 7:55 am
hi,
Which version of SQl are you using?
October 17, 2006 at 8:26 am
SQL SERVER 2005
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply