Purpose
AUDIT_LOG_FILTER_REMOVE_USER() removes a filter from a user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support security audit.
Syntax
AUDIT_LOG_FILTER_REMOVE_USER('user_name');
Description
Parameters
user_name: the username.
Note
The AUDIT_LOG_FILTER_REMOVE_USER function adopts the DROP IF EXISTS semantics. It does not return an error if the object to be removed 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
Remove a filter from the user001 user.
SELECT AUDIT_LOG_FILTER_REMOVE_USER('user001');
The return result is as follows:
+-----------------------------------------+
| AUDIT_LOG_FILTER_REMOVE_USER('user001') |
+-----------------------------------------+
| OK |
+-----------------------------------------+
1 row in set