Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2001
    Posts
    18

    Unanswered: Table ownership defaulting to dbo

    Hullo All

    I've run across a new and interesting issue with an external party's setup of SQLServer 7.

    When I create a new user, give the user permissions to create objects, log on as that user using SQL Server authentication and create a table, the table is created as being owned by dbo and not my new user.

    In any of my internal instances of SQLServer 7 or 2k, when an object is created, it is owned by the user who created it.

    Can anyone offer me any suggestions on why the default ownership to dbo should be occuring, and what I can do to get around this without having to specify an authid before the object name at creation stage or running sp_change_object_owner afterwards?

    It's not the end of the world if there's no way to avoid the above two options, but I'm interested to know why it's happening in the first place.

    Many thanks for any suggestions or answers.

    Megan
    Last edited by Megan; 05-17-02 at 03:02.

Posting Permissions

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