SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[DB Audit] detailed DML operation

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
[DB Audit] detailed DML operation
Author Message
raffaele



Joined: 09 Dec 2009
Posts: 3
Country: Italy

Post [DB Audit] detailed DML operation Reply with quote
Hallo
I would like to know if Db Audit can report in detail which DML operation a user performed: currently, in the Operation Audit Details I see SEL/UPD/INS/DEL operations altogether, without distinction; instead I would like to have a specific tag pointing to the actual DML operation.
Thanks in advance
Wed Dec 09, 2009 5:59 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Please try System Audit / Operations Audit Detail report.
Wed Dec 09, 2009 8:01 am View user's profile Send private message
raffaele



Joined: 09 Dec 2009
Posts: 3
Country: Italy

Post Reply with quote
SysOp wrote:
Please try System Audit / Operations Audit Detail report.

Hallo, thank you for reply.
As I stated, in the Operation Audit Detail report I see SEL/UPD/INS/DEL operations mixed together.
I would like to know if it's possible to log them separately.
Wed Dec 09, 2009 9:24 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Which type and version of the database are you auditing?

PS. audit logging and reporting are 2 different things. Reports are used to aggregate the information; the format of data presentation on reports may differ from the format of the raw audit data stored in audit trail tables.
Wed Dec 09, 2009 9:52 am View user's profile Send private message
raffaele



Joined: 09 Dec 2009
Posts: 3
Country: Italy

Post Reply with quote
I'm auditing a MSSQL2000 SP4 Standard Edition.
Actually, I didn't look in details into the actual log, just to the report.
Wed Dec 09, 2009 9:56 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
This report is grouped by user/terminal/database/schema object/access time. If you want to see the actual SQL command, please use Reports / System and User Activities Reports / Text of SQL Queries.

In case that one doesn't meet your specific requirements too, you can create a custom report to return the required details.
Wed Dec 09, 2009 10:47 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.