Updated on 2025-06-07 GMT+08:00

U0400009: GaussDB does not support the xxx system privilege

Description

Database Type and Version

  • Source database type and version: MySQL 5.5, 5.6, 5.7, and 8.0
  • Target database type and version: all GaussDB versions

Syntax Example

This error is reported because UGO does not convert unsupported system privileges by default.

For example, GaussDB does not support some system privileges of MySQL:

GRANT PROCESS ON DATABASE mysql_demo TO my_user;
GRANT EVENT ON DATABASE mysql_demo TO my_user;

Suggestion

Modify Support for system privilege and comment out the statement. If the privileges required by the user after the conversion are not as expected, you need to manually adjust them.