Results 1 to 4 of 4

Thread: Dbo

  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unanswered: Dbo

    What happens if I am not the database owner and I create a table without using the word "dbo" ??

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The table will fall under your ownership. The table may not be visible or useable by other logins. If there is another table by the same name belonging to the dbo, then code executed by you will use your table while code executed by the dbo or other logins will use the dbo-owned table.

    Its best to avoid this unless for some reason you need to store private data in the database.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    To avoid this, I simply do something that came over from Sybase:

    sp_addalias 'username', dbo

    The problem is is that it is not visible in EM, only if you select it from sysusers in the database.

    Sorry, read the question wrong, nevermind...
    Last edited by PMASchmed; 10-10-06 at 15:57.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I know there may be a need to have different owners for different objects...

    1). I have just never found one
    2). I've seen 3rd party vendors do this, when a simple different table name would have been better
    3). It makes maintanence a nightmare
    4). It does force me to write bullet proof utilities
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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