AUDIT_LOG_FILTER_SET_USER

Purpose

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

Syntax

AUDIT_LOG_FILTER_SET_USER('user_name', 'filter_name');

Considerations

Parameters

• user_name: specifies the user name.

  Note

  AUDIT_LOG_FILTER_SET_USER allows you to specify a user@host that does not exist, or a wildcard. user_name has the following limitations:

  • You cannot specify the host field.
  • Wildcard matching is supported only for the entire field, that is, %. Partial wildcards such as test_% are not supported.

• filter_name: specifies the filter name.

  Note

  AUDIT_LOG_FILTER_SET_USER has the CREATE OR REPLACE semantics. If the specified object already exists, the DDL operation will overwrite it. If the specified filter_name does not exist, the DDL operation will not take effect and no error will be reported.

Return value

The input of the expression 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 output of the expression is the error message.

Examples

Set the log_all filter to the user user001.

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