Purpose
This function (expression) is used to remove a filter from a user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support audit features.
Syntax
AUDIT_LOG_FILTER_REMOVE_USER('user_name');
Considerations
Parameters
user_name: specifies the name of the user.
Note
AUDIT_LOG_FILTER_REMOVE_USER is equivalent to DROP IF EXISTS. If the object to be dropped does not exist, no error is returned.
Return value
The input of the expression must be a string constant, and the output is of the string type.
- If the DDL statement is executed successfully, the expression returns
OK. - If the DDL statement is executed unsuccessfully, the
SELECTstatement still executes successfully, and the output of the expression is an 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