none
Monitoring and Reporting Database Access To Tables

    Question

  • We have a SQL Server 2012 Server with one very sensitive database on it. We wish to retain SA access to the SQL Server but also want to report any SELECt access from the tables in the sensitive database. This will give the business users peace of mind that we will not look at the data without them knowing.

    Can we use something like Extended Events to monitor any SELECT access to tables in a database? Or maybe there is another simpler approach that can be suggested?

    Thanks in advance

    Friday, October 11, 2013 2:38 PM

Answers

All replies