Home Forums SQL Server 2008 SQL Server 2008 - General Best practice - SSIS package question RE: Best practice - SSIS package question
John Mitchell-245523
SSC Guru
Points: 148809
More actions
October 16, 2012 at 5:36 am
#1549479
Grant SELECT permission on the objects it needs to read from, then. Depending on exactly what data you're trying to read, the VIEW DEFINITION permission might be appropriate.
John