Hello, I`m a System Auditor looking for an audit program to SQL. I´ll apreciate any help.
Hello, I`m a System Auditor looking for an audit program to SQL. I´ll apreciate any help.
SQL Server 2008 offers a tool called SQL Server Audit. It basically uses extended events to track what happens on the server. You have a degree of control over it. Here is a good place to start reading about it.
Permissions audit?
Access audit?
I have created an access/ logon audit based on logon triggers. Example http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2005logontriggers/2366/
To audit permissions, I recommend you check out this article. http://jasonbrimhall.info/?p=391
2 People are following this question.