Change Request
Please answer the following questions before submitting your issue. Thanks!
- Describe what you find is inappropriate or missing in the existing docs.
https://docs.pingcap.com/tidb/stable/ticdc-sink-to-mysql/#permissions-required-for-the-downstream-database-user
If upstream runs a DDL create table db1.t1(..., y_id bigint references db2.t2(id), ...), the downstream user will need REFERENCES privilege on db2.t2 to successfully create this table db1.t1. Since this is not mentioned in documentation, the customer may forget to grant this privilege and causes the changefeed to fail.
- Describe your suggestion or addition.
The simplest is just include "REFERENCES" privilege into the list.
- Provide some reference materials (such as documents and websites) if you could.
Change Request
Please answer the following questions before submitting your issue. Thanks!
https://docs.pingcap.com/tidb/stable/ticdc-sink-to-mysql/#permissions-required-for-the-downstream-database-user
If upstream runs a DDL
create table db1.t1(..., y_id bigint references db2.t2(id), ...), the downstream user will need REFERENCES privilege ondb2.t2to successfully create this tabledb1.t1. Since this is not mentioned in documentation, the customer may forget to grant this privilege and causes the changefeed to fail.The simplest is just include "REFERENCES" privilege into the list.