Is there a way to execute a DTS package from a VB application without
the user having sysadmin privileges? Is there a grant execute command
or other means? We have a VB application that will be used by several
lower privileged customers. We don't want clear-text passwords in any
code or ini file.

Thanks

In message <1114653004.772489.161780 (AT) f14g2000cwb (DOT) googlegroups.com>, paul
<dstickrod (AT) yahoo (DOT) com> writes
There is no role required to execute a package, but when called from VB
the package will execute on the users machine under the users security
context, so they will need rights perform the actions inside the
package. Using SQL security may abstract them from this somewhat, but
any files for example will need to be available to them.

They may also need the public role in msdb, which all users get by
default, to load the package if stored in SQL Server.

It may be better to devise an alternative process which means the job is
executed on the server, which hopefully means another more privileged
security context Perhaps it can be scheduled?

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

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

These are on-demand requests. Guess we could use a scheduled DTS
package to poll for a tickler request and execute it, but that's not
what we had in mind.

Are there any other creative means to run the package from the SQL
server?