Re: Execute DTS Package from non-privileged VB Client
- From: Darren Green <darren.green@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 28 Apr 2005 07:48:13 +0100
In message <1114653004.772489.161780@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>, paul <dstickrod@xxxxxxxxx> writes
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
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
.
- Follow-Ups:
- References:
- Prev by Date: Execute DTS Package from non-privileged VB Client
- Next by Date: Re: how to return the result of execute sql programmatically
- Previous by thread: Execute DTS Package from non-privileged VB Client
- Next by thread: Re: Execute DTS Package from non-privileged VB Client
- Index(es):
Relevant Pages
|
