What is the best way to setup SQL Server audit to get all SELECT for schema?

0 votes

2 answers

218 views

                          My goal:
1. Show all tables from specific schema which are used in SELECT queries for all users in SQL Server database.
2. [Optional] Show all tables from specific schema which are used in queries for all users (around 300 sql and AD users) except one user in SQL Server database.

I have added specification:

But still see deletes/inserts/updates:

Questions:
1. Is audit log best option to achieve my goal ?
2. What specification should I use ?

Asked by adam.g (465 rep)

Sep 27, 2024, 01:04 PM
Last activity: Jul 3, 2025, 02:08 AM

What is the best way to setup SQL Server audit to get all SELECT for schema?

Related Questions