英文:
Azure Synapse Analytics - Dedicated Pool - Create user - Incorrect syntax near 'PASSWORD'
问题
我正在尝试使用以下命令在 Synapse Dedicated Pool 中创建包含的用户：
create user [username]
with password = 'Comple@xPassword@123'
default_schema = 'dbo'
它失败并显示以下错误消息：
> 在第 3 行，第 2 列发生解析错误：'PASSWORD' 附近的语法不正确。
在 Azure SQL 数据库中运行正常，但在 Synapse Dedicated Pool 中失败。感谢您的帮助。
谢谢，
Praveen
英文:
I'm trying to create a Contained Users in Synapse Dedicated Pool using the below command
create user [username]
with password = 'Comple@xPassword@123'
default_schema = 'dbo'
It's failing with the below error message
> Parse error at line: 3, column: 2: Incorrect syntax near 'PASSWORD'.
It works fine in Azure SQL Database. However, it fails in Synapse Dedicated Pool. Any help in appreciated.
Thanks,
Praveen
答案1
得分: 1
根据文档：
"SQL Database支持使用SQL Server身份验证的包含数据库用户，但Azure Synapse Analytics不支持。"
英文:
As per the documentation:
“SQL Database supports contained database users using SQL Server authentication, but Azure Synapse Analytics does not.”
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论