GoldenDB as the Source

GoldenDB system table mysql.user

Permission to collect information about USER and ROLE objects.

1. Create a user.

CREATE USER <user> IDENTIFIEDBY passwd;

GRANT SELECT ON mysql.user TO <user>;

Process

Permission to view all tables in information_schema.

Run the following statement:

GRANT PROCESS ON *.* TO db-user;

Object collection

Permission to collect objects

Run the following statement:

GRANT SELECT ON <schema_name>.* TO <user>;

GRANT SHOW VIEW ON <schema_name>.* TO <user>;

GRANT TRIGGER ON <schema_name>.* TO <user>;

Stored procedure and function

In MySQL 8.0.20 and later versions, if there are stored procedures and functions in the source database, grant the user SHOW_ROUTINE permission.

Run the following statement:

GRANT SHOW_ROUTINE ON *.* TO <user>;