Blog Post

Azure Synapse Analytics Blog
3 MIN READ

Read Only Permissions in Synapse SQL

CharithCaldera's avatar
CharithCaldera
Icon for Microsoft rankMicrosoft
May 08, 2020
The Object level / Schema level permissions can be provided in Azure Synapse Analytics using SQL statements. There are be several ways that this can be achieved with different SQL syntax.   EXEC ...
Updated May 09, 2020
Version 3.0
Synapse Administration
Synapse SQL
synapse support
nickywong's avatar
nickywong
Copper Contributor
Mar 08, 2024

Hello I did try your comment to grant "Select" access to the user. 

 

It said it was successfully  executed under the screenshot below 

 

But when I checked the next step, it still shows as 'Null' based on db_datareader under permission _name. 

 

 

 

 

was there any restriction I didn't know that's why it didnt work?