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.
4,878 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
We have several schemas inside a dedicated sqlpool. I want to give Truncate privilege to all the objects of a particular schema to a AAD group.
I found the below syntax:
EXEC sp_addrolemember 'db_ddladmin', 'Azure AD Group';
But it seems that it will provide that privilege across all other schemas as well. How can i restrict to a particular schema.
you can use DCL rather than the sys proc
GRANT ALTER on schema::schemaname to 'Azure AD Group'