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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 db_dtsoperator

Author  Topic 

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-05-13 : 16:48:56
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.

Thanks


Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-05-16 : 13:52:23
No one knows how to grant user permission so that he should able to just export package but should not able to do any other thing?
Go to Top of Page

latch
Yak Posting Veteran

62 Posts

Posted - 2011-05-20 : 10:52:42
did you check these:

http://social.msdn.microsoft.com/Forums/en-SG/sqlintegrationservices/thread/ffc8bb3b-c649-4584-8007-82a68e8b9c0e
Go to Top of Page
   

- Advertisement -