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
Author
Message
Posted Thursday, May 31, 2012 1:51 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:52 AM
Points: 119, Visits: 450
Hi,

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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:11 AM
Points: 2,361, Visits: 6,744
Who is also shown. If you look at the first http://www.sqlservercentral.com/Images/14239.jpg
you will session_server_principal_name which will show the user name


-Roy
Post #1309369
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse