Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Understanding the Difference between Owners and Schemas in SQL Server
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 10/05/2007 :  08:57:20  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote

SQL Server 2005 introduces the concept of schemas as opposed to object owners found in previous versions. This article will explain the differences between the two and, hopefully, clear up some of the confusion that still exists about schemas.

Read Understanding the Difference between Owners and Schemas in SQL Server

Starting Member

1 Posts

Posted - 10/05/2007 :  17:54:35  Show Profile  Reply with Quote
Thanks for the article Kathi!

Edited by - Rockstar on 10/05/2007 17:54:50
Go to Top of Page

Starting Member

1 Posts

Posted - 10/18/2007 :  06:25:59  Show Profile  Reply with Quote
Hi there,

I'm coming from Oracle world, and I've been struggling to have developpers understand the advantage of using schemas, in a similar fashion on Oracle and SQL Server.

I like the idea of a -DEFAULT- schema in certain circomstances, but you can't assign it to a db user if it's mapped to a Windows group/user login.
Now, we try to use ONLY Windows groups as instance logins, following Microsoft recommandation.

I've seen few questions about this fact on the web, but no answer.

Does anyone here know, if it will be implemented in a future fix / SP / release ?
And why it is not ? Security issue, I guess, but can't figure it out...

As for your article, I would like to add, as of schemas benefits, that granting control or select on an entire schema, is more secure, and equivalent in a developper's view, to
granting db_owner or db_datareader on a database.
Go to Top of Page

Starting Member

4 Posts

Posted - 05/15/2009 :  12:24:46  Show Profile  Reply with Quote
Can you inherit from a schema? For example, say I created a base set of tables (in schema dbo) for an application but wanted to create extension tables for different customers. If I create a SchemaForCustomerA could they inherit tables from schema dbo or would they just use them?

Thank You.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000