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 the audit feature.
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)