In article <04b601c38906$eb9cd980$a301280a (AT) phx (DOT) gbl>, Derek Ruesch
<druesch (AT) rocheconstructors (DOT) com> writes
You cannot disable a user from executing a package if they can load it.
The most obvious way to prevent a user loading a package is to put a
package password on the package and only tell authorised users.

If the package is stored in SQL Server (Local Packages) then you can
deny the user access to the msdb database. This prevents them from
retrieving the package from the SQL Server, hence they cannot execute
it.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org