Hi, I am looking into how the Audit plugin works. The thing I need is to include some connection variables in an audit record. Use case: User attempts to login into my web app When a connection is established, if a user was authenticated, I execute the SET APP_USER = 'user@domain.com' I want to …

Hi Jovan, Why do you need to set “APP_USER = X”? Is it because the app connects to the DB with a generic user and you need to differentiate each user? Currently audit log does log every CRUD (and every other operation) and prints user@host that executed it, but no way of printing any extra details…

Including some extra data in Audit record

MySQL & MariaDB Percona Server for MySQL 8.0

Jovan_Perovic November 7, 2022, 3:40pm 3

Hey Carlos,

Yes, that is the exact goal I wanted to achieve - use one generic DB user but keep a record of actions every application user executed.

Thanks, I am going to open a feature request and hope for the best

Best regards,
Jovan

1 Like

Topic		Replies	Views
Percona Audit Log Percona Server for MySQL 8.0 mysql , percona	3	886	May 12, 2023
About the user filtering of mysql percona audit plugin Percona Server for MySQL 5.7	0	1034	January 14, 2019
Audit plugin include/exclude accounts doesn't seem to work Percona Monitoring Plugins	9	2310	December 10, 2020
Audit plugin excluded accounts still being logged Other MySQL® Questions mysql , percona	1	850	September 26, 2022
Audit plugin include/exclude accounts doesn't seem to work Percona Monitoring Plugins	8	1675	December 11, 2020

Including some extra data in Audit record

Related topics