Security Audit
-
Hi
I need to design a new process for Security Audit.. Could anyone give me some idea what could be adopted.
The idea is as below:
1. To populate the login history from the SQL Log to a Database File.
2. To generate various report from that. I guess SSRS will be best for this purpose.
Also, could any one please guide me how to proceed on Step 1.
Many thanks in advance.
Regards
Utsab Chattopadhyay
-
To get the login information you have to think of a solution that best suits your needs. I have a service that checks the syslogins database view every 10 secs and if it finds a new connection it goes and writes to a table in one of our databases. You can't use trigger in system objects. So yo can thinnk and let know if there is any.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
When you toggle auditing on, the audit events get written to the Application event log for the server. It's a simple matter to use a tool like EventCombMT to parse the log for the events.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply