It's not possible to select any tables from the schema while CDC is enabled.
Connector: SQL Server
Please check to make sure the database user has the correct database role membership.
Make sure that you add the database user to the designated role you used when creating the CDC instance:
ALTER ROLE <rolename> ADD MEMBER <databaseUser>;
To easily manage the permissions in your databases, SQL Server provides several roles that are security principals that group other principals. They are like groups in the Microsoft Windows operating system. Database-level roles are database-wide in their permissions scope.
There are two types of database-level roles:
- Fixed-database roles that are predefined in the database
- User-defined database roles that you can create.
For more information, you can view Microsoft's Database-level roles documentation.