| Author |
Message |
raffaele
Joined: 09 Dec 2009
Posts: 3
Country: Italy |
|
 [DB Audit] detailed DML operation |
 |
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 |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
Please try System Audit / Operations Audit Detail report.
|
|
| Wed Dec 09, 2009 8:01 am |
|
|
raffaele
Joined: 09 Dec 2009
Posts: 3
Country: Italy |
|
| |
|
 |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
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 |
|
|
raffaele
Joined: 09 Dec 2009
Posts: 3
Country: Italy |
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7955
|
|
| |
|
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 |
|
|
|
