Issues with configuring audit of sensitive data groups in SQL Server

  • 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 1 month, 1 week ago by  Paul-S.
    • This topic was modified 1 month, 1 week ago by  Paul-S.
  • Thanks for posting your issue and hopefully someone will answer soon.

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply