Add sql user as DBO

Orenc 0 Reputation points
2023-02-02T19:38:58.6866667+00:00

I need to add SQL USER as dbo in Azure sql DB

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,461 Reputation points MVP
    2023-02-02T20:09:56.53+00:00

    Database and object ownership can be transferred using the ALTER AUTHORIZATION command.

    ALTER AUTHORIZATION ON DATABASE::<YourDatabaseName> to [TheNewOwner];
    
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.