Hello,

i want to audit user actions including the sql-statement on IDS 11.1.
Is there any possibility to combine the sql-statement with the logs.

Are there hidden switches on the onaudit command?

Does sombody log it inside the DB with a stored procedure?


Regards, Mike

I recommend either:

1) Use AGS Server Studio to capture SQL samples at timed intervals.
2) Enable SQLTRACE in Open Admin Tool and poll the "sysadmin:sqltrace*" tables with sufficient frequency to record statements of interest.

Regards,
Doug Lawry
Oninit Consulting