Post reply

DTS Access Permission

  • December 4, 2006 at 9:55 am

    #63016

    Hi All,

    I have a requirement to give user specific permission to DTS packages for Execution.

    e.g

    Let there be 2 users A and B and 2 DTS packages D1 & D2.

    The requirement is like A should have permission to run only D1 (but not D2)

    and B should have the permission to run D2 (not D1)

    Can anybody let me know how this can be solved?

    Thanks in Advance

    Pratyus

  • December 4, 2006 at 10:15 am

    #675536

    Pratyus,

    You can protect each DTS with different password for this purpose.

    Regards

    Utsab Chattopadhyay


    CDBA

  • December 4, 2006 at 10:28 am

    #675538

    Thanks Ustab,

    but i want the user can only see his authorised DTS package only.not all.

    Is there any way to give permissions for that.

    Thanks

    Pratyus

     

     

  • December 4, 2006 at 11:30 am

    #675552

    There is no option to hide few dts packages from one user and the few from other...

    You can hide everything or not...

    Execute permissions can be granted in a different way to execute the dts package...

    You can create a bat file and with package name as passing parameter and change the bat file to executable and give that executable to user and hide the package name from him...

    This way you can give the access to the user to execute the dts package without giving him the access...

    Note: This is also not 100% pefect solution...

     

     

    MohammedU
    Microsoft SQL Server MVP

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

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