March 30, 2015 at 5:34 pm
I need the users to be able to kick of an SSIS package which creates an attachment and then emails that attachment out.
The users should not have direct access to the attachment or the folders in which it is temporarily stored before being attached to an email.
It doesn't seem possible to allow the users to run the package which writes, deletes and reads attachment to this folder and prevent them from accessing it another way. From all accounts the user need logon access to the server to be able to save to a temp folder on the server.
We were hoping to run the package as a different user by having the stored procedure which calls it do an "execute as".
However, we are unable to work out what permissions need to be set and are running around in circles.
Does anyone know how to set-up a package so that it can be run by a stored procedure which uses the "execute as " command ?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply