Fixed Server Role to run DTS
-
Which is the appropriate fixed server role that can run DTS only? I have a programmer who needs to run DTS to populate one of his databases but I do not wish him to have access 'sa' as there are other databases on the server that I do not wish him to damage, however involuntary.
Madame Artois
-
It's not so much dts authentication, rather it's at database level.
As long as the account has authority to the objects in the package (eg database connections, stored procs etc), then it will be fine.
------------------------------
The Users are always right - when I'm not wrong! -
Thanks. We are sorted now
Madame Artois
-
Whoops we aren't sorted. The programmer reports that he can access DTS but it doesn't bring through his data. I will give him 'Process Administrator' rights for him to test (he is already part of dbowner) but if anyone has any more ideas, please let me know soonest.
Madame Artois
-
If he is only reading data out of the table then give him db reader on the database.
If he wants to insert as well give him db datawriter additionally.
That should be enough access.
------------------------------
The Users are always right - when I'm not wrong! -
I have given the user the rights just on the database and withdrawn 'Process Administrator'. I'll see how he gets on and report back.
Madame Artois
-
The programmer reports all is OK i.e. he is now getting data. Thanks
Madame Artois
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply