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-16 : 11:26:42
|
| I posted this in ssis section but no one replied. May be someone from database side knows it. Here is my question:Hi,How to revoke 1. Execute all packages and 2. Execute all packages in SQL Server Agent.from db_dtsoperator. I am giving permission to user to just see listing of packages, export packages.In short users should be able to export package but should not able to exeute it.Thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2011-05-16 : 11:54:04
|
| Sounds to me like you should remove this user from the db_dtsoperator role. Perhaps just granting SELECT for the user on the appropriate msdb table(s) will resolve your problem.Be One with the OptimizerTG |
 |
|
|
|
|
|
revoke execute