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.
| Author |
Topic |
|
pitmanfan
Starting Member
25 Posts |
 Posted - 2007-01-09 : 13:57:32
|
| i've inherited a DTS package from a DBA thats left the company. its usually ran by DBAs but the business now want to run the package themselves. the package connects to two servers which only allow connections using windows authentication. the problem i have is that the package needs db_owner rights to run and i dont want to give this to the business users. i want the users to be part of a role and the db_owner rights to be granted to this role at the beginning of the package and revoked at the end but i dont know any way this can be done without using sql authentication.any help would be appriciated.... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-10 : 04:02:42
|
| With sql server authentication they won't be able to run anything which can grant themselves dbo rights (not without doing things you wouldn't want to do).Can you create a job which runs the package and give them something to start the job - means the package will run on the server rather than their workstation.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
permissions whilst running a DTS package