GoldenDB as the Source Database Type
Check Item |
Description |
Suggestion |
---|---|---|
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;
NOTE:
|
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 ; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot