Question
Why can't I select any tables from the schema when I already have CDC enabled?
Environment
Connector: SQL Server
Answer
Check the database user has correct database role membership.
Make sure you add the database user 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: fixed-database roles that are predefined in the database and user-defined database roles that you can create.
For more information you can view Microsoft's Database-level roles documentation.