Skip to main content

SQL_PermissionChanges Job

The SQL_PermissionChanges Job provides detailed information on permission changes for all database objects, specifically objects containing sensitive data.

Analysis Tasks for the SQL_PermissionChanges Job​

Navigate to the Databases > SQL > 2.Activity > SQL_PermissionChanges > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis task(s). The analysis task(s) are preconfigured for this job.

Analysis Selection

The default analysis tasks are:

  • SQLServer Permission Changes – Creates the SA_SQLServer_PermissionChanges_Details table accessible under the job’s Results node
  • Permission Changes Instance Summary – Creates the SA_SQLServer_PermissionChanges_InstanceSummary table accessible under the job’s Results node. This analysis task summarizes permission change activity per instance.

In addition to the tables and views created by the analysis tasks, the SQL_SensitiveDataActivity Job produces the following pre-configured report.

ReportDescriptionDefault TagsReport Elements
Permission Change ActivityThis report lists all permission change related SQL events, and summarizes them by instance.NoneThis report is comprised of three elements: - Bar Chart – Displays top instances by permission change activity - Table – Provides details on instances by permission change activity - Table – Provides details on event details