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 |
|
harrisw48
Starting Member
34 Posts |
 Posted - 2006-05-17 : 09:28:43
|
| I have a DTS that runs and initially truncates a table then loads data.I dont want anyone to be able to change the DTS or the database/tables but they need to run the DTSI have given db_datawriter and db_datareader on the database but the dts fails when the DTs runs on the truncate table part.Any ideas |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-05-17 : 11:26:34
|
| They need to have access to msdb to be able to run DTS packages.. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-17 : 12:20:08
|
| for truncate table you need to be owner of the table, dbo or sysadmin (I think).You could probably change it to delete if the user has write access but it might be too slow or use up the tr log.==========================================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. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-17 : 12:21:37
|
| You can only truncate a table if you are the table owner, the database owner, a DDL Admin, or a server admin.Change your DTS package to use DELETE instead of TRUNCATE.CODO ERGO SUM |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-17 : 12:26:39
|
| lol :) - missed the ddl admin though.==========================================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. |
|
|
|
|
|
|
Read an Change rights