MSSQL Server audit

sakuraime 2,276 Reputation points

I have a audit action like in the following

is it possible to filter by login/ database username ??

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,572 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Thomas LaRock 76 Reputation points Microsoft MVP

    Should be possible with the SUCCESSFUL_LOGIN_GROUP. Here is the complete list of audit groups and actions.

    No comments

  2. Cris Zhan-MSFT 6,561 Reputation points

    Hi @sakuraime ,

    It appears that you are creating a database audit specification.

    You can filter logins or database users in the SQL Server audit instead of audit specification level . Right-click the audit name(ie Audit-20120408-152028) in SSMS, select "Properties", enter the predicate or WHERE clause on the "Filter" page, for example: ([server_principal_name] <> N'sa'), ([database_principal_name]<>N'dbo')). Or you can also use T-SQL to Create or alter SQL Server Audit.

    SQL Server Audit Records

    No comments