I created a VB.Net appliction that creates and executes a couple of
DTS packages. I use trusted connection in my connection objects.

I then deployed these applictions to a user's machine.

I had to create a login on the SQL server and promote them the the
Serve Administrator role so they could run the package from their
machine.


I would like to know if anybody knows what the minimum settign I can
use but still allow them to run the packages?


Or maybe change the connection properties?


Thanks,
RWiethorn

In article <553a0349.0308211017.e3005d1 (AT) posting (DOT) google.com>, rwiethorn
<rwiethorn2002 (AT) yahoo (DOT) com> writes
If using a trusted connection, and the package is run from the users
desktop then the user must have permissions to do everything, including
run all the SQL that is done in the package.

Using a trusted connection in DTS is just like in a VB program or
similar, the current user is the user that makes the connection, hence
they run the SQL.

Just remember DTS is a client side application.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

In order for the user to use the appliction, I had to create a Login
and Give them SYSTEM ADMIN Server Roles.

I would rather not do that.

We are using mixed mode for security.

ANy ideas on the what roles I need to use other than Sys Admin?


Darren Green <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote

Package 1 requires DELETE permissions on table
Package 2 requires INSERT and SELECT permissions
Package 3 requires Exec permissions on stored proc (providing ownership
chain is complete)

That should be that.


When the user does not have sysadmin privs what messages do you see ?

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org