AUDIT_LOG_FILTER_REMOVE_FILTER

Purpose

This function (expression) is used to delete a filter.

Syntax

AUDIT_LOG_FILTER_REMOVE_FILTER('filter_name');

Considerations

Parameters

filter_name: specifies the name of the filter.

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 SELECT statement 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