Post reply

Why should prevent creation of new DTS packages...

  • June 13, 2003 at 9:23 am

    #175957

    Help!

    I'm at a loss on how to do this... I'm frantactically looking for a solution in BOL and perhaps it's just my lack of sleep (been up till 2 am), but I would appreciate any pointers in the right direction. I have a developer working on a database on my server. Because he has a history of auto-deleting/dropping databases into thin air I've been very restrictive with his access, he does not have access to any of the other databaes, but he does have owner rights to his own. I prevent him from adding new logins w/o permission. and yesterday he still managed to keep about 4 instances of EM running where he was modifing the same table and field names from 2 instances and locked up the server until I kicked him off w/ the kill users script on this site. (thanks by the way)

    so in short, how do I prevent him from creating new DTS packages?

    Thanks,

    -Francisco


    -Francisco

  • June 13, 2003 at 10:00 am

    #461338

    Remove guest from msdb and do not give him access to this database.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

  • June 13, 2003 at 10:12 am

    #461344

    My personal preference is to break all of his fingers, but I know that probably won't be considered acceptable.

    There's an FAQ with some more details if you want to get really specific with permissions:

    http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=252

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • June 13, 2003 at 11:02 am

    #461356

    I like the "break all his fingers" option. but I suppose this may not fly with his boss, although my boss would probably do it for me . Thank you for your posts, I will investigate the link. Thanks for your tip on removing guest from this database. I will investigate if he is still able to create any new DTS packages.

    more background, he converted an Excel solution to sql it will now be using a ".Net" gui interface instead of being in excel. Well his solution was to recreate each of the 200 spreadsheets as tables, so we have a denormalized database on our server... arg. I will snap one day I know I will.....

    Thank for your help and direction...

    -Francisco

    Edited by - fhtapia on 06/13/2003 11:03:28 AM


    -Francisco

  • June 14, 2003 at 8:12 pm

    #461437

    Does he have a sister?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply