Post reply

Permission needed to view only 'Management | Legacy | DTS'

  • November 1, 2007 at 10:27 am

    #178921

    A developer required permission to -view only- the dts packages stored in SQL2005 Maintenance.

    I tried BOL, and experimenting with login properties, server roles, and securables. But I couldn't find a definitive answer. I thought maybe, serveradmin. All help is appreciated

  • December 2, 2007 at 1:09 pm

    #756302

    Do you mean Integration Services packages? Maintenance Plan packages??

    These are stored in msdb in various tables. You could give SELECT access to these tables to the developer.

  • December 5, 2007 at 10:04 am

    #757389

    The developer was using SSMS and could not view the legacy dts pkgs. If I gave him sysadmin permissions, he could access them. I would prefer that he only be able to view them. These legacy dts packages are under Management | Legacy | Data Transformation Services in SQL2005 SSMS.

    Thanks for the reply

  • December 5, 2007 at 10:40 am

    #757395

    I'm not sure if there's a role in 2005, but I'm guessing you could give him SELECT rights on the DTS tables in MSDB, or even the whole database, and he could read them.

  • December 5, 2007 at 2:01 pm

    #757439

    Granting SELECT on sysdtspackages in msdb will allow the developer to view the legacy packages.

    Greg

    Greg

  • December 10, 2007 at 7:39 am

    #758601

    Thanks Greg, and Steve! That works!

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

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