Why can't I select any tables from the schema when I already have CDC enabled?
Connector: SQL Server
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 and user-defined database roles that you can create.
For more information you can view Microsoft's Database-level roles documentation.