question

arkiboys avatar image
0 Votes"
arkiboys asked 02137510 commented

synapse workspace sql pool access to created schemas

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

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered 02137510 commented

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for you

0 Votes 0 ·