Purpose
This function (expression) is used to delete a filter.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support audit features.
Syntax
AUDIT_LOG_FILTER_REMOVE_FILTER('filter_name');
Considerations
Parameters
filter_name: specifies the name of the filter.
Note
AUDIT_LOG_FILTER_REMOVE_FILTER has the same semantics as DROP IF EXISTS. If the object does not exist, no error will be returned.
Return value
The input must be a string constant, and the output is a string.
- If the DDL operation is successful, the expression returns
OK. - If the DDL operation fails, the
SELECTstatement still executes successfully, and the output of the expression is the error message.
Examples
Delete the filter log_all.
SELECT AUDIT_LOG_FILTER_REMOVE_FILTER('log_all');
The return result is as follows:
+-------------------------------------------+
| AUDIT_LOG_FILTER_REMOVE_FILTER('log_all') |
+-------------------------------------------+
| OK |
+-------------------------------------------+
1 row in set