Purpose
AUDIT_LOG_FILTER_REMOVE_FILTER() deletes a trigger.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support security audit.
Syntax
AUDIT_LOG_FILTER_REMOVE_FILTER('filter_name');
Description
Parameters
filter_name: the name of the filter.
Note
The AUDIT_LOG_FILTER_REMOVE_FILTER function adopts the DROP IF EXISTS semantics. It does not return an error if the object to be deleted does not exist.
Return value
The input of the function 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 is still successfully executed, and the expression outputs an error message.
Examples
Delete 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