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 |
|
nicole
Yak Posting Veteran
97 Posts |
 Posted - 2006-03-05 : 20:51:09
|
| Hello, I have a problem regarding DTS Access Control.I have all databases, dev, uat, and production, on the same server. However, we don't want the developers to create/modify/delete DTS of the production database. Is there any way I have this kind of control? |
|
|
mcarahul
Starting Member
11 Posts |
Posted - 2006-03-06 : 03:37:07
|
| According to my understanding you want the developers to only see the DTS. You dont want them to create, modify, delete and execute any DTS. If this is the scenario then you can make a common group to access DTS and give the rigths accordingly.Rahul Sharma |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-06 : 06:26:18
|
| Simply don't give developers any access to the Production box as they really shouldn't have any need for any form of access. If they ever need it, then grant on an ad-hoc basis.. |
|
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-03-06 : 20:25:56
|
no, no, no  The developers can create/modify/delete DTS for dev DB, but should have NO access for those of the production DB. Since the dev and production DB are on the same SQL server, all DTS are under the same msdb, that means I have to set control on each DTS  It will be perfect if the developers can have full control for the DEV database, but can't do anything related to the production database. Please help    |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-07 : 08:09:50
|
| Move the Production DB off a development box as this is potentially very dangerous..Other than that, not sure there's anything you can do as they will need access to msdb to be able to develop.. |
|
|
|
|
|
|
|
|
DTS Access Control