You can use role-based access control (RBAC) to set permissions for Spark and SQL separately. The available roles and what each allows is listed in the documentation: https://learn.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac-roles
Azure synpase workspace notebook / sql script permission
sakuraime
2,351
Reputation points
How Can I control the notebook and sql script permission ??
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.