AUDIT_LOG_FILTER_SET_USER

Purpose

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

Syntax

AUDIT_LOG_FILTER_SET_USER('user_name', 'filter_name');

Parameters

Parameters

• user_name: specifies the user name.

  Note

  AUDIT_LOG_FILTER_SET_USER allows you to specify a non-existent user or a wildcard in the user@host field. The user_name field has the following limitations:

  • You cannot specify the host field.
  • You can only use the % wildcard to match the entire user field, not partial wildcards such as test_%.

• filter_name: specifies the filter name.

  Note

  AUDIT_LOG_FILTER_SET_USER has the CREATE OR REPLACE semantics. If the specified filter_name does not exist, the DDL operation does not take effect but does not return an error.

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 expression returns an error message.

Examples

Set the log_all filter to the user001 user.

SELECT AUDIT_LOG_FILTER_SET_USER('user001', 'log_all');

The return result is as follows:

+-------------------------------------------------+
| AUDIT_LOG_FILTER_SET_USER('user001', 'log_all') |
+-------------------------------------------------+
| OK                                              |
+-------------------------------------------------+
1 row in set