0
votes
0answers
32 views

How to audit all activity for a Windows Group in SQL Server 2012/2014?

I have a Windows Group called (say) MYDOMAIN\MyDBATeam. This AD group has all the AD accounts for the DBA team. I have auditing set up using server-side traces at the moment and want to move away from ...
2
votes
2answers
163 views

How do I maintain more audit history?

I created a SQL Server audit and when I view the audit logs I only see today’s audit. I am saving it to a file and I want to store audit for one year. Is there a way to store database and server audit ...
4
votes
2answers
511 views

Track grant permission on tables

I'd like to see if there are any changes on the permissions granted for a specific table. For example, I don't want to have the login 'John' have the SELECT permission on the table Invoices. If ...
3
votes
0answers
299 views

Tracking object use using SQL Auditing

I am looking for a solution to track object usage in my database. Objects such as tables, stored procedures, and functions. I discovered SQL Auditing and was under the impression that it's exactly ...