Is it possible to assign DTS package read-only privilege?

  • Many thanks in advance.

  • 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