Grant access to View SSIS project/package validation/execution logs on SSISDB

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  March 30, 2016 at 2:20 pm

  #326143

  Is there an option to grant access to developers to see SSISDB project/package validation and execution logs on production db?

  Many thanks!

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  March 31, 2016 at 7:04 am

  #1868830

  Solution:

  ALTER the following views in SSIS catalog.

  Catalog.event_messages

  Catalog.executions

  Catalog.validations

  --Comment it to give access to reports

  --WHERE opmsg.[operation_id] in (SELECT [id] FROM [internal].[current_user_readable_operations])

  -- OR (IS_MEMBER('ssis_admin') = 1)

  -- OR (IS_SRVROLEMEMBER('sysadmin') = 1)

  After updating views, developer can view executions and drill down messages. Connect to server and you can be able to view reports.