|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
need urgent help to restrict TargetServerRole...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. |
|||||||||||||||||||||||