Post reply

Fixed Server Role to run DTS

  • April 12, 2006 at 4:52 am

    #90997

    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

  • April 12, 2006 at 6:48 am

    #632071

    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!

  • April 12, 2006 at 7:53 am

    #632096

    Thanks.  We are sorted now

    Madame Artois

  • April 13, 2006 at 3:54 am

    #632293

    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

  • April 13, 2006 at 8:40 am

    #632413

    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!

  • April 19, 2006 at 1:31 am

    #632997

    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

  • April 20, 2006 at 2:48 am

    #633189

    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