GRANT Database Scoped Credential syntax gives mismatched input error

Question

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?

Answer 1

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];