Is it possible to prevent a user from creating a DTS package?

Question

Post reply

Is it possible to prevent a user from creating a DTS package?

Allan Chen

SSC Veteran

Points: 238
More actions
April 5, 2006 at 12:23 pm

#167675

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Allan Chen SSC Veteran Points: 238 More actions · Answer 1

Allan Chen

SSC Veteran

Points: 238

April 5, 2006 at 1:17 pm

#631085

I found the solution...all I needed is to remove the exec privilege on sp_add_dtspackage stored procedure from the public.

Thanks,

--Allan

Hans Lindgren SSChampion Points: 10494 More actions · Answer 2

Hans Lindgren

SSChampion

Points: 10494

April 6, 2006 at 2:44 am

#631151

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