Edit on GitHub
Cannot Select Tables From the Schema While CDC Is Enabledlink
Issuelink
It's not possible to select any tables from the schema while CDC is enabled.
Environmentlink
Connector: SQL Server
Resolutionlink
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>;
Causelink
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, see Microsoft's Database-level roles documentation.