0

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

Prawin
  • 1,158
  • 2
  • 12
  • 26
  • 1
    “ SQL Database supports contained database users using SQL Server authentication, but Azure Synapse Analytics does not.” https://learn.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable?view=sql-server-ver16 – wBob Jul 03 '23 at 07:29

1 Answers1

1

As per the documentation:

“SQL Database supports contained database users using SQL Server authentication, but Azure Synapse Analytics does not.”

https://learn.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable?view=sql-server-ver16

wBob
  • 13,710
  • 3
  • 20
  • 37