openrowset Questions

Azure – Grant a login SELECT on some Synapse Serverless Views, but not ability to run OPENROWSET on entire Datalake

August 1, 2023
bbb0777
2 Answers

For SQL Server based login in Synapse Serverless, as soon as I run these two things: use master GO Create Login JustTest WITH PASSWORD='Whatever' use somedatabase Create User JustTest from login JustTest Now, JustTest can run any OPENROWSET query on…

VIEW QUESTION

Executing an OPENROWSET on azure synapse result in a 'Resolving CosmosDB path has failed with error 'Secret is not base64 encoded.''

December 13, 2022
fidou
2 Answers

I am deploying to an azure synapse environment queries using sqlcmd to serverless pool. The environment contains an SQL database that my deploying account has access to. I am creating first the credentials to access a cosmosDB with : CREATE…

VIEW QUESTION