DTS Permissions

Hello all

Hope someone can help, I have set up a new user and restricted his acces to the db,

how can I allow him to read DTS packages but not change or execute them?

Thanks

Richard

Hey Richie,

Which version of SQL Server are you using?|||IF those DTS package is owned by SA and scheduled as a job then you need to give this user permission in TARGETSERVERROLE role.