Purpose
This function (expression) is used to remove the filter from the user.
Syntax
AUDIT_LOG_FILTER_REMOVE_USER('user_name');
Description
Parameters
user_name: the username.
Note
AUDIT_LOG_FILTER_REMOVE_USER has the semantics of DROP IF EXISTS. Dropping non-existent objects will not cause an error.
Return value
The input expression must be a string constant, and the output is of the string type.
- When the DDL statement is executed successfully, the expression returns
OK. - When the DDL statement fails, the
SELECTstatement is still executed successfully, and the expression outputs an error message.
Examples
Remove the filter from 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