SQL Server Performance

User unable to execute DTS Package.

Discussion in 'SQL Server DTS-Related Questions' started by honeyvirus, Oct 17, 2006.

  1. honeyvirus New Member

    Hi,<br /><br />I am having problems making a User able to execute a DTS Package.<br />This User has the db_owner permissions on the Database that holds<br />the objects accessed in the Package. The user isnt the sysadmin <br />but has been given datareader and datawriter on MSDB too.<br /><br />Does the user need further permissions inorder to execute DTS packages.<br /><br />Also, The Package is owned by another User who has sysadmin rights.<br />The owner is able to execute the package. Does the fact that the <br />package isnt owned by "sa", the cause of this issue??<br /><br />Anyhelp on this welcome!!<br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Honey.<br /><br />
  2. ranjitjain New Member

Share This Page