Note
- For V4.3.x, this view is available starting with V4.3.3.
- For V4.2.x, this view is available starting with V4.2.4.
Purpose
The mysql.audit_log_filter view displays the definitions of audit filters.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support audit features.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| NAME | varchar(64) | NO | The name of the filter. |
| FILTER | longtext | NO | The definition of the filter. |
Sample query
Query the definitions of audit filters.
obclient [mysql]> select * from mysql.audit_log_filter;
The query result is as follows:
+---------+-------------------------------+
| NAME | FILTER |
+---------+-------------------------------+
| log_all | { "filter": { "log": true } } |
+---------+-------------------------------+
1 row in set (0.003 sec)