Note
This view was introduced in OceanBase Database V4.2.4.
Purpose
The mysql.audit_log_filter displays the definitions of audit filters.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support security audit.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| NAME | varchar(64) | NO | The name of the filter. |
| FILTER | longtext | NO | The definition of the filter. |
Sample query
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)