Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: Informix 11.1 audit

    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

  2. #2
    Join Date
    Feb 2011
    Location
    London
    Posts
    6
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •