Issues with configuring audit of sensitive data groups in SQL Server

• Paul-S

  SSC Veteran

  Points: 267

  More actions

  May 16, 2022 at 5:27 pm

  #4033831

  I'm attempting to configure the "sensitive" versions of the batch completed audit groups (SENSITIVE_BATCH_STARTED_GROUP/SENSITIVE_BATCH_COMPLETED_GROUP) that are listed in the doc for SQL 2019

  https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-action-groups-and-actions?view=sql-server-ver15

  I have set up all the data classifications and now would like to set up the associated auditing.

  Issue is I can't select them in the UI (they're not in the dropdown list) nor can I use them in T-SQL or PowerShell scripts either and just get syntax errors ...

  E.g. Whilst using BATCH_STARTED_GROUP works just fine, replacing just those characters in the same script with SENSITIVE_BATCH_STARTED_GROUP produces a syntax error ...

  

  Am I missing a configuration option or something similar ?

  Running SQL 2019 (15.0.4223.1) with SSMS 18.11.1

  • This topic was modified 3 years, 1 month ago by Paul-S.
  • This topic was modified 3 years, 1 month ago by Paul-S.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 17, 2022 at 6:10 pm

  #4034476

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.