Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2016
    Posts
    1

    Unanswered: Can not capture user doing a delete action on an audit table

    Dear all,
    Audit table captures insert and update but doesn't capture delete. How can you go about this to make sure it also captures users deleting tables in a share user id environment?

    Thanks
    Edris

  2. #2
    Join Date
    Jun 2004
    Posts
    793
    Provided Answers: 1
    Strange, I thought that AUDIT TABLE did capture delete.

    AUDIT INSERT , UPDATE , DELETE
    ON scott.emp
    BY ACCESS;
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Sep 2016
    Location
    Pune
    Posts
    5

    Can not capture user doing a delete action on an audit table

    Hey all.
    Audit table captures insert and update but not delete. Does, anyone have an idea on how to solve this issue?

    Thanks

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,088
    Provided Answers: 4
    Who set the audit? How, exactly? Are you sure you are auditing deletes, but nothing happens? Documentation is rather clear about it; it can be done if you set it correctly up.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,504
    Are you talking about deleting the .AUD flat files, then do there is now way to audit them. Are you talking about auditing the deletion of wors in a table, then audit will audit that.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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