Schemas | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Schemas

I heard SQL Server 2005 has a new option called "Schemas". If this is true, does that mean, i can create user’s like "SA", "SA1" and create same objects under these user schemas?
Schemas are collections of db objects under the same namespace. I could do a lot of typing – or you can search for "User-Schema Separation" on SQL 2005 BOL, which will explain about schemas and how they relate to db users.
quote:Originally posted by california6 I heard SQL Server 2005 has a new option called "Schemas". If this is true, does that mean, i can create user’s like "SA", "SA1" and create same objects under these user schemas?
Yes…
You can have the same object with different schemas like diffent owners in sql 2000…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Read DInesh’s articlehttp://www.sql-server-performance.com/da_authorization_2005.asp too in addition to BOL topic. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thank you CG2000, Satya and Mohammed for the info. It’s really helpful.
]]>