About this question
I created a test account for checking permissions against. It currently has the db_datareader, db_datawriter, and db_ddladmin roles for the Northwind database. But when it tries to create a new schema on Northwind, the creation fails if it tries to authorize dbo as the schema owner, what's up?
Version: SQL Server Management Studio: 15.0.18183.0 Microsoft Analysis Services Client Tools: 15.0.1487.0 Microsoft Data Access Components (MDAC): 10.0.18362.1 Microsoft MSXML: 3.0 6.0 Microsoft Internet Explorer: 9.11.18362.0 Microsoft .NET Framework: 4.0.30319.42000 Operating System: 10.0.18362
How sql server create new schema?