Determine which users have permission to execute SSIS packages

• derkin

  SSC-Addicted

  Points: 468

  More actions

  July 9, 2010 at 5:55 am

  #237569

  Is there any script or method to identify which logins have permissions to execute or edit an SSIS package?

  I am assuming they need to be members of db_dtsadmin or other roles but how to identify them?

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  July 13, 2010 at 7:30 pm

  #1192476

  Hi,

  You can find role members by running this query:

  EXEC msdb..sp_helprolemember 'db_dtsadmin'

  More details about SSIS roles are here: http://msdn.microsoft.com/en-us/library/ms141053(SQL.90).aspx