Do you mean you want someone to be able to open a package but not save or execute it? If so, grant EXEC permission on sp_get_dtspackage, but deny permission on sp_add_dtspackage to prevent saving new versions. They're both in msdb.
Greg
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply