April 5, 2006 at 12:23 pm
Hi,
Is there a way to prevent a user from creating DTS packages? We have a guideline stating that only DBA can create and maintain DTS packages in production environments. Despite that, a new developer created a DTS with password protected in our production server. We are just wondering if there is a switch or privilege that can be used to prevent anyone other than the DBA from creating DTS package.
Any suggestion would be greatly appreciated.
--Allan
April 5, 2006 at 1:17 pm
I found the solution...all I needed is to remove the exec privilege on sp_add_dtspackage stored procedure from the public.
Thanks,
--Allan
April 6, 2006 at 2:44 am
Remember that there are more then one SP that controls access to DTS packages. Search for all SPs with the name DTS in them and you will be surprised by the number returned.
Hanslindgren
April 6, 2006 at 6:04 am
This should also help you :
http://support.microsoft.com/default.aspx?scid=kb;en-us;282463
http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp
April 6, 2006 at 6:04 am
This should also help you :
http://support.microsoft.com/default.aspx?scid=kb;en-us;282463
http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply