Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-05-12 : 16:22:00
|
| Hi experts,I am granding group of users to import ssis packages from development to production. I granted db_dtsltduser role in msdb. Users can import package from dev to prod. But problem is that they can also delete packages which we dont want. Is there a way that users should just import packages but not able to delete? I tried to revoke execute on sp_dts_deletepackage but no vain. Any help will be appreciated.Thanks |
|
|
latch
Yak Posting Veteran
62 Posts |
|
|
|
|
|
revoke delete privileges