1-
In the synapse workspace, I am using the serverless sql pool.
2-
Using the SQL Scripts in the Develop tab, I created schemas, schema1, schema2, schema3
3-
Using the SQL Scripts in the Develop tab, I created views in each of the schemas,
i.e.
schema1.view1...
schema2.view2...
schema3.view3...
4-
Report developers can now access these views in all the schemas.
Question:
How can I limit the report developers to have access only to schema3 views only?
Thank you