Note
This view was introduced in OceanBase Database V4.2.4.
Purpose
The mysql.audit_log_user view displays the mappings between audit filters and users.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support security audit.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| USER | varchar(128) | NO | The username. |
| HOST | varchar(128) | NO | The name of the host. |
| FILTERNAME | varchar(64) | NO | The name of the filter. |
Sample query
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)