Note
- This view is available starting with V4.3.3 for V4.3.x.
- This view is available starting with V4.2.4 for V4.2.x.
Purpose
The mysql.audit_log_user view displays the mapping between audit filters and users.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support audit features.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| USER | varchar(128) | NO | The username. |
| HOST | varchar(128) | NO | The host name. |
| FILTERNAME | varchar(64) | NO | The filter name. |
Sample query
Query 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)