Results 1 to 4 of 4

Thread: DTS permission

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Question Unanswered: DTS permission

    I created a DTS package to extract data to a text file.

    I want to create a login for a user who should be able ONLY to run this DTS. I don't want to give him/her any access to any database .

    Is that possible?

    Thanks in advance

    Giorgio

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Without permission on database user cannot complete the execution of DTS package.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Posts
    2
    I find out a workaround:

    1) I created a user that has permission only on the sample DB Northwind.

    2) The DTS package is protected by "DTS Owner password" and DTS User password

    3) The "Connection" in the DTS package has inside a username and password that has acess to the appropriate DB.

    With this workaround I obtained that:

    1) The user has access only to the Northwind DB
    2) The user can run only the DTS package (because is protected with DTS User password).

    Thanks anyway to everyone who replied to me!

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Then my reply was intended to light when you said no permission to any database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •