synapse workspace sql pool access to created schemas

Question

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

Answer 1

Hi @arkiboys ,

Thanks for using Microsoft Q&A !!
You can use schema level permissions using GRANT Schema Permissions to limit access to only Schema3 for your report developers. So, you can provide a select, alter etc permissions for specific report developers on schema 3 only. For example, following statement will grant only select permissions to your report developers on schema3 -
Grant SELECT ON SCHEMA :: schema3 TO [report-user]

Please let me know if you have any questions.

Thanks
Saurabh

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.