Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

What, when and who? Auditing 101 - Part 3 Expand / Collapse
Posted Thursday, May 31, 2012 1:51 PM


Group: General Forum Members
Last Login: Thursday, September 25, 2014 4:29 AM
Points: 119, Visits: 451

Very nice article.

So am i right in saying this form of auditing only answers the "when" and not the "who", I saw session Id but unless your constantly recording whose using the session Id that doesn't tell you anything?

Post #1309333
Posted Thursday, May 31, 2012 2:57 PM



Group: General Forum Members
Last Login: Yesterday @ 7:39 AM
Points: 2,370, Visits: 6,765
Who is also shown. If you look at the first
you will session_server_principal_name which will show the user name

Post #1309369
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse