SQL Server Performance

User VS Schema

Discussion in 'Getting Started' started by xiebo2010cx, Jun 26, 2007.

  1. xiebo2010cx Member

    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
    ------------------
  2. MohammedU New Member

    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.
  3. satya Moderator

    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.

Share This Page