Associate a dataset with multiple schemas

What is the problem or goal the end user is trying to solve or accomplish?

It's possible to create a virtual dataset that queries multiple schemas. This dataset would only get mapped to a single schema, so permissions wouldn't be entirely validated (if dataset queries Schemas A and B and it gets linked to Schema A, a user that doesn't have access to Schema B would be able to see its charts).

How are they solving it currently?

Not possible to solve it.

What is the recommended solution by the Customer?

Implement the ability to link a dataset to multiple schemas, so that only users with access on all schemas can view it.