Skip to Content
avatar image
Former Member

Audit in MaxDB

Hi,

There is a way to audit data changes in a MaxDB instance, and save a history of what was changed?

Regards

Clóvis

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 27, 2008 at 11:32 AM

    Hi again Clovis!

    MaxDB does not provide a automated data change tracking and also no auditing feature (which would allow to track data access as well).

    A generic approach to such a requirement is the use of database triggers that log changes into seperate log tables.

    How exactly you implement such triggers depends on the exact requierments you have.

    E.g. for a NetWeaver database it would not be sufficient to log the database user that peformed a change as all SAP users share the same database user.

    If you tell us more details of what you want to do with this homebrew-audit-feature I can perhaps provide an example how an implementation could look like.

    regards,

    Lars

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Lars,

      nice to see you again too, and i'm happy you still have patience to reply open source users. 😉

      I think that here i will have same problem you explain as Netweaver,(i know nothing about Netweaver, only the name) since in my application i use same connection for different users, that connections are taken from a pool, then maybe audit with triggers isn't a option, and i cant set in Connection what is the current system user, right?

      then the better approach is to make that audit system in my persistence layer, where i know what is the user, and what objects are inside that transaction.

      regards

      Clóvis