AUDIT_LOG_FILTER_REMOVE_USER

Purpose

This function (expression) is used to remove a filter from a user.

Syntax

AUDIT_LOG_FILTER_REMOVE_USER('user_name');

Purpose

Parameters

user_name: specifies the user name.

Return value

The input of the 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 SELECT statement still executes successfully, and the output of the expression is the error message.

Examples

Remove a filter from the user user001.

SELECT AUDIT_LOG_FILTER_REMOVE_USER('user001');

The return result is as follows:

+-----------------------------------------+
| AUDIT_LOG_FILTER_REMOVE_USER('user001') |
+-----------------------------------------+
| OK                                      |
+-----------------------------------------+
1 row in set