Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    12

    Unanswered: Capture activity on a single table

    Hi

    UDB V8 Fixpack 14 EEE
    OS : AIX

    We have a buisness requirement to track all activity on a particular table. All selects , inserts,updates and deletes should be captured with userid , timestamp when they have executed and sql user used . After collection we should generate monthly reports on all activites on that table for auditiing purposes.

    I have done researsh on db2aduit facility & query patroller both are not suitable for this situation as it does on whole database which will add a overhead, Also tried to use a triggers it only captures DML activities. Is there are any other ways , any suggestions will be appreciated.

    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I do not know if this will work, but you could try this:

    1) use the triggers to log the DML
    2) create a stored procedure to log read events
    3) create a table UDF that calls the SP and returns the table rows
    4) create a view on the UDF
    5) revoke select access on the table

    Andy

Posting Permissions

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