Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    218

    Unanswered: schema/user details in SQL Server2005

    We are using SQL Server2005 on Windows XP.

    My question is:
    What is the difference b/w schema, owner and user in SQL Server 2005. The reason for asking is that when I login as a user say 'user1' and create objects under it.. they should show up in its own schema - right. Because this is how Oracle works. Now we are not seeing this behaviour in SQL Server2005. Instead, we see the object created with <dbo>.<object_name>.

    Are we missing something? thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Because SQLServer is not Oracle

    schema - collection of objects
    owner - owner of object(s)
    user - user who is configured to SQLServer

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    In SQL 2005, a user can be given a default schema. And why would you expect Oracle and SQL Server to act the same?

  4. #4
    Join Date
    Sep 2003
    Posts
    218
    thanks for the response.. I don't expect them (Oracle, SQL Server or DB2) to act the same.. they are good in their own ways...

    Now back to the issue.. SQL Server2005 is taking 'dbo' as default schema despite creating a user specific schema!! hence the question.

    Thanks.

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    By default (and mainly for backward compatibility), All users will have DBO as the default schema, unless specifically told otherwise. You can change the user with the alter user command.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •