Home All Groups Group Topic Archive Search About

need urgent help to restrict TargetServerRole...

Author
3 Aug 2006 10:15 PM
=== Steve L ===
need some expert advices here.

background sql2k with sp4

i granted some developers TargetServerRole for msdb to wirte and
maintain dts for their applications but only found out that with that
role, one can pause and even stop sql server! also, they can write dts
packages to add ole db provider to transfer tables from database they
do not have  permission for to a database they have permission for and
read everything from there. they also are able to browse master
database even i don't give them permission for the master database.

they do need permission to create and maintain dts packages and
scheduled jobs. so what can i do to revoke the unexpected permissions i
mentioned earlier? thank you.

AddThis Social Bookmark Button