title: Integration Services Catalog folder permissions changed
body: <p>Question: Do any of the SQL Server systems tables in either SSISDB or MSDB contain information that would allow me to discover which users are making changes to folder permissions in the Integration Services Catalog?</p>
  
  <p>Background: I saw that a SQL Agent Job was failing with the following error description:</p>
  
  <blockquote>
    <p>Cannot access the package or the package does not exist. Verify that
    the package exists and that the user has permissions to it.</p>
  </blockquote>
  
  <p>Upon researching the issue, I found that the service account's permissions to the folder that contains the relevant packages has been removed. I would like to perform a diagnostic to see who removed the permissions and when.</p>
  
  <p>Additionally, configuration management by our IT Operations Group has been a challenge as the SQL Servers have not been kept in-line across environments (i.e., development, test, stage, and production) with respect to at least the following:</p>
  
  <ol>
  <li>Patch Management</li>
  <li>Memory Management</li>
  <li>Permissions Management</li>
  </ol>
  
  <p>Research: I have checked the Sysssispackages table in MSDB but that does not appear helpful and the tables in SSISDB all appear to be integer based. My background is in database development and less so in database management. Any help is appreciated.</p>