GoldenDB as the Source Database Type

GoldenDB system table mysql.user

Permission to collect information about USER and ROLE objects.

1. Create a user.

CREATE USER db-user IDENTIFIEDBY passwd;

GRANT SELECT ON mysql.user TO db-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 db-user;

GRANT SHOW VIEW ON schema-name.* TO db-user;

GRANT TRIGGER ON schema-name.* TO db-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 db-user ;