Purpose
This function (expression) is used to remove 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: the name of the filter.
Note
AUDIT_LOG_FILTER_REMOVE_FILTER is equivalent to DROP IF EXISTS. If the specified object does not exist, no error is returned.
Return value
The input of this expression must be a string constant, and the output is of the string type.
- If the DDL operation is successful, the expression returns
OK. - If the DDL operation fails, the
SELECTstatement still executes successfully, and the output result of the expression is the error message.
Examples
Remove the log_all filter.
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