Overview
The mysql.audit_log_user view is used to display the mapping relationship between audit filters and users.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| USER | varchar(128) | NO | Username |
| HOST | varchar(128) | NO | Host name |
| FILTERNAME | varchar(64) | NO | Filter Name |
Sample query
View the mapping between audit filters and users.
obclient [mysql]> select * from mysql.audit_log_user;
The query result is as follows:
+---------+------+------------+
| USER | HOST | FILTERNAME |
+---------+------+------------+
| user001 | % | log_all |
+---------+------+------------+
1 row in set (0.003 sec)