SQL Server Performance Forum – Threads Archive

User VS Schema

In SQL 2K, user and schema seems the same thing.
In SQL 2K5, they are separated. What is the essential difference bewteen these two? ——————
Bug explorer/finder/seeker/locator
——————

The separation of the schema from the owner makes administrative changes easier, but that is a big deal because it greatly increases the chances you won’t keep an old account active because it’s a pain to change owners on objects. There’s also more granularity and ease of administration using the schema as another level of assigning permissions. SQL Server 2000
Security Owner = Schema, hard to remove old users at times Schema is separate.
SQL Server 2005
Better granularity in easily controlling security. Logins can be authenticated by certificates. And also read "CREATE SCHEMA" and "CREATE USER" topic in BOL…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

http://msdn2.microsoft.com/en-us/library/ms190387(SQL.90).aspx fyi. 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.

]]>