Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    BC, Canada
    Posts
    17

    Unanswered: Detail audit info collection

    Hi guys,

    I installed the Sybase audit process and enabled logging (audit) for inserts, update and delete actions for some tables. In a reference manual it is pointed that additional info (details about changes, like what was changed, inserted or deleted) can be collected in the extrainfo column. So far I can collect only a "header" info, e.g. when, who and where but not what.

    Please let me know what I am missing and how to get that detailed level of logging.

    Thanks,
    Marin
    Marin Kostadinovic
    ----------------------------
    DBA
    DIMM Info Systems Inc.


  2. #2
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97
    Sybase ASE stores different info in the extrainfo column for the several audit options available. As you saw, there is not much for INSERT, UPDATE or DELETE.

    It's bizarre that older manuals (as v12.5) are more descriptive about the extrainfo contents than newer manuals (as v15.7)

    Regards,
    Mariano Corral Herranz

Posting Permissions

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