SQL Server Performance Forum – Threads Archive
Taking ownership of a DTS packageHello 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)
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
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.