Cannot Select Tables From the Schema While CDC Is Enabled

Issue

It's not possible to select any tables from the schema while CDC is enabled.

Environment

Connector: SQL Server

Resolution

Ensure that the database user has the correct database role membership.

The database user should be added to the designated role you used when creating the CDC instance:

ALTER ROLE <rolename> ADD MEMBER <databaseUser>;

Cause

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:

1. Fixed-database roles that are predefined in the database.
2. User-defined database roles that you can create.

For more information, see Microsoft's Database-level roles documentation.