Reputation
1,866
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
11 26
Newest
 Yearling
Impact
~122k people reached

Jul
8
answered What is the proper way to store a full table of data outside of a database? It needs to be able to be restored as well
Jul
2
awarded  Curious
Apr
27
awarded  Yearling
Apr
23
revised sql-audit wiki description
added 394 characters in body
Apr
23
revised sql-audit wiki excerpt
added 117 characters in body
Apr
23
accepted SQL Server Audit Specification - filter DML by all but one user
Apr
23
comment SQL Server Audit Specification - filter DML by all but one user
Totally get what your saying... but if I can make them happy without having to buy another TB of storage to hold the audit data I would rather. Thanks for info.
Apr
23
comment SQL Server Audit Specification - filter DML by all but one user
Back to original question... so, that's a no then :)
Apr
23
comment SQL Server Audit Specification - filter DML by all but one user
The auditors don't care about what DML the application is doing - only people logging directly into the server. We have controls for storing the service account passwords away from users - managed by security team. So, auditors don't want it - we're going to filter it to report on it - why store it at all?? A year worth of DML on this application would be a HUGE amount of data. Don't get me wrong - I get your statement... but this approach makes the auditors happy.
Apr
23
revised SQL Server Audit Specification - filter DML by all but one user
edited title
Apr
23
wiki created sql-audit description
Apr
23
wiki created sql-audit excerpt
Apr
23
suggested approved edit on sql-audit tag wiki
Apr
23
suggested approved edit on sql-audit tag wiki excerpt
Apr
23
asked SQL Server Audit Specification - filter DML by all but one user
Apr
17
awarded  Popular Question
Mar
20
awarded  Notable Question
Feb
12
awarded  Popular Question
Feb
4
awarded  Custodian
Feb
4
reviewed Reject What would cause an orphaned ##MS_PolicyEventProcessingLogin##?