SQL Server Performance

Taking ownership of a DTS package

Discussion in 'SQL Server DTS-Related Questions' started by camachiux, Sep 7, 2004.

  1. camachiux New Member

    Hello all,

    I'm new in this forum and it really looks excellent.
    I have a problem, I have a Windows 2003 user account that needs rights to execute a DTS package, one of the steps in that package runs a system stored procedure xp_cmdshell, that writes in a textfile the date, time and errors. This user account has no privileges, and I don't want to assign the System Administrator Role to that account.

    I have 2 questions:
    1. What permissions should I assign to the user in order that he can run the system stored procedures?
    2. How can I change the ownership of a DTS package? I used the sp_changeobjectowner with the tables, but it does not work to a DTS package.

    Thanks in advance,

    Jose Luis Camacho

    (Moved from General DBA forums)
  2. Raulie New Member

    In earlier versions of SQL Server a user had to be a member of sysadmin but not no longer, you can grant a user access to this stored procedure but it is not safe. Refer to Books online for details of xp_commandshell.

    To change ownership of a DTS package refer to this link.

    http://www.databasejournal.com/features/mssql/article.php/1461511
  3. satya Moderator

    1) Ensure to grant permissions for that user to execute the SP and on corresponding tables, check whether insert permission is required.
    2) Follow the link supplied by Raulie.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page