feat(cdc-source): check privilege on creating a CDC table

[fuyufjh]

Is your feature request related to a problem? Please describe.

About CDC connector, is it possible to detect this when creating the cdc source?

connector-node   | Caused by: org.postgresql.util.PSQLException: FATAL: must be superuser or replication role to start walsender

Otherwise, unless checking the logs, users will only see create table .. with connector='postgres_cdc' succeed but no data comes in. 🙁

Describe the solution you'd like

Detect this when creating the cdc source and throw an error to users.

Describe alternatives you've considered

No response

Additional context

No response