Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,545
    Provided Answers: 11

    Unanswered: user modified audit

    Db2 v11 ese on linux
    on tables we want to create a kind of simple audit who/when modified tis row
    for timestamp it is easy as you can specify generated fore each row.....
    but I could not find this to save the user that executed the i/u
    It can be done with triggers, but with the quantity of tables we have, it is a lot of maintenance
    any special register/setting for a column that could be applied to save for Update the user
    for insert you could specify generated, but, no control if they specify the column with insert
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    306
    Provided Answers: 46
    Create an audit policy with 'execute' category and audit all your tables needed with this audit policy.
    You get not only the modification statements, but other statements as well. You can filter them out later processing the audit events file.
    Regards,
    Mark.

Posting Permissions

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