SQL Server Performance Forum – Threads Archive

SQL User Audit

Is there a way to audit a user and send email alert to a group when a user logs into sql server. I know this can be done by capturing data in profiler for the specific user and have a job that scans this data and use xp_sendmail to alert the dba.

Something like sp_who ‘login’? Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

May review links:
http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx
http://www.windowsitpro.com/WindowsSecurity/Article/ArticleID/22317/22317.html
http://vyaskn.tripod.com/sql_server_security_best_practices.htm
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>