I have an existing Laravel application that is using Doctrine as its ORM. I have a hacked-together audit logging solution for a couple tables, but now I want to expand my logging of database changes to a much larger set of tables -- dozens -- and my hacked-together solution isn't looking like the right way to do things.
I've checked out the MariaDB Audit Plugin, and it looks nice, but I want to verify before I get too excited: Is there a way that I can use the MariaDB Audit Plugin to log not just the database username that initiates a change, but also the application username?
In other words, if my .env file contains MariaDB auth information for MyServerSideConfiguredMariaDBUser and Laravel user AliceSmith logs into my Laravel app using her browser, then makes a change to some data via my Laravel app, I want to know that Laravel user AliceSmith made that change -- not just that MyServerSideConfiguredMariaDBUser made the change (which will always be the case).
Does that makes sense? Is such logging possible using this tool?