The MongoDB connector runs the following command to check if the provided user has "appropriate" permissions for what the source/sink connectors will do with the respective Mongo database.
{{db.runCommand(
{connectionStatus: 1, showPrivileges: true});}}
CosmosDB Mongo API does not support yet the `connectionStatus` command as per this link: https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/feature-support-42
While the immediate answer would be to drop CosmosDB and use a "real" MongoDB backend, things are not always that simple. Besides, in the case of CosmosDB Mongo API, this check is unrealistic because the user does have the necessary permissions, so skipping the check would not cause any harm.
I propose that there is a new configuration entry (false by default) that allows that: skipping user permissions check.
Will follow up with a link to the appropriate PR, just want to raise this ticket first so I can link it in the PR.