Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Salesforce
  3. Question
Salesforce

Why can't I create a new schema with the authorized owner set to dbo?

Asked by Buffy Heaton Apr 22, 2021 1.5K views 1 answer
Share

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?

Create Schema Failed

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?

Your answer

1 Answer

More Salesforce discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest Salesforce Blogs

Guides, tips and career advice on Salesforce from JanBask experts.