Azure Synapse Analytics, change database owner

Darren Price 21 Reputation points
2020-08-19T23:40:19.003+00:00

Any one know how to change the database owner on a azure synapse sql database to follow best practice to set owner as a disabled logon.

Successfully updated azure sql using the command below but does work on a synapse datase on the same azure sql server
ALTER AUTHORIZATION ON database::synapsedb001 TO disabledlogin

get an error saying:

Securable class 'database' not supported in this version of SQL Server

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,631 questions
0 comments
Accepted answer
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2020-08-20T15:42:31.203+00:00

    Hi @Darren Price ,

    Welcome to Microsoft Q&A Platform.

    This is not supported in Synapse as it is based on Data Warehouse architecture. Only class types - SCHEMA and OBJECT are supported. As per MS documentation, this command applies only to SQL Database. I confirmed the same with Product team internally.

    I would recommend you to provide feedback at the feedback forum. All the feedback you share, is closely monitored by the Synapse Product team and implemented in future releases.

    Hope this helps! Please let us know for further queries and we will be glad to assist. 19241-altersnap.png

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest