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 |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
 Posted - 2008-03-06 : 04:22:25
|
| I've got a situation where I would like a user to have access to creating and modifying a DTS package , and also to be able to set up a job to run the DTS package. But I don't want them to have full SysAdmin rights. On the other hand I do need the Job and DTS to run as 'sa'Apart from defining a specific username / password , is there a specific role that could a user can be added to , which allows them to set up the job as 'sa'?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-06 : 07:43:05
|
No. Never let anyone use sa, and never let anything run as 'sa'Set up specific user id's and grant the necessary permissions.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-06 : 22:53:28
|
| Only sysadmin can set job owner to sa. |
|
|
|
|
|
|
DTS permissions