Currently, the $shardedDataDistribution aggregation stage can only be executed against the 'admin' database and it retrieves all sharded collections across the entire cluster.

Task objectives:

• Enable the $shardedDataDistribution stage to run against specific databases beyond 'admin'. The final behavior would be:
  • When executed against the 'admin' db, it will return all sharded collections in the cluster (same as the current behavior).
  • When executed against any other db, it will return only the sharded collections for that specific database.
• Adjust the required user privileges based on the target database.

• • For the 'admin' database: Users must have the shardedDataDistribution action privilege (same as the current behavior).
  • For other databases: Users must have the listCollections action privilege for the target database.