Note
This view is available starting with V4.2.4.
Overview
The mysql.audit_log_user view is used to display the mapping relationship between audit filters and users.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support the audit feature.
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)