Blog Post

Azure Synapse Analytics Blog
5 MIN READ

Grant user permissions for ad-hoc analytic using OPENROWSET in SQL endpoint of Synapse Workspace

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Jun 26, 2020
Azure Synapse Analytics Workspace enables you to read the files from Azure Data Lake storage using OPENROWSET(BULK <file url>). In this article you will see how to grant minimal permission to the use...
Updated Jun 26, 2020
Version 5.0
Synapse Administration
Synapse Security
Synapse SQL
cbslc's avatar
cbslc
Copper Contributor
Mar 13, 2022

I am unable to reproduce the results you get with openrowset. I constantly receive "Failed to execute query. Error: Parse error at line: 2, column: 6: Incorrect syntax near 'openrowset'."

 when using any of the examples above in Azure Synapse. Thoughts?