# Is it possible to extract the user connection details and DDL statements into a MySQL table in Percona MySQL 8.4.7?

**URL:** <https://forums.percona.com/t/is-it-possible-to-extract-the-user-connection-details-and-ddl-statements-into-a-mysql-table-in-percona-mysql-8-4-7/40097>\
**Category:** MySQL & MariaDB\
**Tags:** mysql\
**Created:** [January 23, 2026, 4:42pm UTC](https://forums.percona.com/t/is-it-possible-to-extract-the-user-connection-details-and-ddl-statements-into-a-mysql-table-in-percona-mysql-8-4-7/40097 "2026-01-23T16:42:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ramasamy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ramasamy/32/16466_2.png) [@Ramasamy](https://forums.percona.com/u/Ramasamy)\
**Post date:** [January 23, 2026, 4:42pm UTC](https://forums.percona.com/t/is-it-possible-to-extract-the-user-connection-details-and-ddl-statements-into-a-mysql-table-in-percona-mysql-8-4-7/40097/1 "2026-01-23T16:42:35Z")

</div>

With the new audit filter plugin introduced in Percona MySQL Server 8.4.x, is it possible to extract the user connection details and DDL statements into a MySQL table in Percona MySQL 8.4.7 for our Security reports (daily logins, dropped users, users executed DDL statements, etc) and adhoc queries required by Security team?

---

<div class="post-metadata">

**Author:** ![anil.joshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anil.joshi/32/13100_2.png) [@anil.joshi](https://forums.percona.com/u/anil.joshi)\
**Post date:** [February 16, 2026, 6:04am UTC](https://forums.percona.com/t/is-it-possible-to-extract-the-user-connection-details-and-ddl-statements-into-a-mysql-table-in-percona-mysql-8-4-7/40097/3 "2026-02-16T06:04:40Z")

</div>

@Ramasamy

You can set the required filter using the function audit\_log\_filter\_set\_filter() mentioned here: [Filter the Audit Log Filter logs - Percona Server for MySQL](https://docs.percona.com/percona-server/8.4/filter-audit-log-filter-files.html#examples). However, I don’t see any direct way to have the information in the table as well. You might need to read from the audit log file and ingest it into the target table. I’ll check more about this internally and get back to you.

> This function, when provided with a filter name and definition, adds the filter.
> 
> [Audit log filter functions, options, and variables - Percona Server for MySQL](https://docs.percona.com/percona-server/8.4/audit-log-filter-variables.html#audit_log_filter_set_filterfilter_name-definition)

> This function assigns the filter to the selected user account.
> 
> [Audit log filter functions, options, and variables - Percona Server for MySQL](https://docs.percona.com/percona-server/8.4/audit-log-filter-variables.html#audit_log_filter_set_useruser_name-filter_name)

Currently, these formats - [Overview - Percona Server for MySQL](https://docs.percona.com/percona-server/8.4/audit-log-filter-formats.html#audit-log-filter-file-format-overview) are available.