CODEWITHSUNDEEP
azureazure-sql-databaseazure-synapseazure-purview
nam
nam

Reputation: 23749

GRANT Database Scoped Credential syntax gives mismatched input error

I am working on this MS Azure article: Connect to and manage Azure Synapse Analytics workspaces in Azure Purview. But in Grant permission to use credentials for external tables section of the article, when I run the following query, I get the error shown below:

SQL: GRANT REFERENCES ON DATABASE SCOPED CREDENTIAL::[mySynapseWorkspace] TO [myPurviewAccountName];

Error:

mismatched input 'SCOPED' expecting ':'

Question: What may be a cause of the error, and how can we fix it?

Upvotes: 1

Views: 1052

Answers (1)

KarthikBhyresh-MT
KarthikBhyresh-MT

Reputation: 5034

I learn from a similar issue logged that you should be providing your credential name and username instead.

Try,

GRANT REFERENCES ON DATABASE SCOPED CREDENTIAL::[your_credential_name] TO [your_username];

Upvotes: 1

Related Questions