Audit Logs

  • Hello,

    I was thinking if this plugins gives information logs/ Audit logs for when and what was the record edited?
    If not what are possibility of implementing this functionality via code?

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi thinkun,

    What kind of audit functionality are you looking for? There are audit plugins for MySQL and MariaDB. Not all free. Can you use one of these? These are proven concepts. If you just want to write dml actions to a log file or another database, you could write your own database triggers.

    What is your goal?

    Best regards,
    Peter

    Thread Starter thinkun

    (@thinkun)

    Hi Peter,

    Using your plugin, when i have given access to Editor level user to access a table. Now when this user updates the record via edit option or Delete it. I need a log of that.
    Is that possible? and how?

    Thanks

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi,

    The plugin does not support logging. Sorry!

    You can write your own database triggers to implement logging, but you will not be able to assign log actions to specific users. This is generally not possible with WordPress, since all WordPress database actions are performed by one database user.

    I can think of two possible solutions:

    (1) The plugin allows you to use remote databases. You could add a remote database connection for specific user groups and let user groups use that connection. The connection can be used in your Data Project pages. Different Data Project pages can use different connections. You would still need to write your own database triggers. You’ll be able to assign actions to user groups, but you still cannot assign actions to specific users. Would that be sufficient?

    (2) Add you own logging code to the plugin. That’s a lot of work! Let me know if you want to do this. To simplify and structure this, I can add some hooks or filters.

    What do you think…?

    Best regards,
    Peter

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Audit Logs’ is closed to new replies.