SQL 2K DTS Permissions Listing

• Ross McMicken

  SSCarpal Tunnel

  Points: 4438

  More actions

  May 16, 2008 at 8:43 am

  #75216

  Is there an easy way to list the permissions granted on DTS packages? The auditors want to know who has what access to DTS packages on our SQL 2000 servers.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 16, 2008 at 8:49 am

  #816552

  You could list permissions for sysdts... tables and stored procedures with dts in their names in msdb database.

  Greg