Post reply

Privelages required for DTS

  • August 12, 2002 at 5:29 pm

    #105007

    Hi All

    I was wondering if anyone could give me an idea on what privelages are required to develop and run DTS packages.

    Environment is Win2k and SQL2k with a few overbearing DBA's that want the development environment locked down as tight as production.

    Thanks

    Phill

    --------------------
    Colt 45 - the original point and click interface

  • August 13, 2002 at 5:49 pm

    #434531

    Anyone with the SQL Server client tools can develop and save DTS packages locally. They can only access DB's that they have been given access to. To save packages to SQL Server, they would have to have access to the MSDB database.

    Diane

  • August 26, 2002 at 8:11 am

    #435328

    HI I understand but, i didn't got exactly on what privelges the dts will run the package.

    venkatesh


    venkatesh

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

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