Disabling DTS For Certain users | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Disabling DTS For Certain users

How can i disable certain users from running DTS /import and export without affecting their noramal read operations in sql query analyser
Checkhttp://vyaskn.tripod.com/sql_server_dts_best_practices.htm DTS best practices and KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;282463 fyi, I think it is not possible to restrict on certain areas of DTS. I believe SSIS is good at this feature. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.