Post reply

ownership of tables

  • August 15, 2006 at 10:12 am

    #61607

    Hi,

    I share a development db with another developer. We both have dbo access but still have to reference the objects we create with each other's user name.

    (eg select * from bloggsj.mytable)

    Is there a way allow both of us to reference all the objects in our db without having quotes our usernames them. As I say, we both have dbo access.

    Any help welcome,

    Eamon

  • August 15, 2006 at 11:50 am

    #655121

    When you create your tables create them with dbo as owner.

    CREATE TABLE dbo.mytable

    instead of

    CREATE TABLE mytable

    If you dont use the prefix dbo the table will created within the scope of the user creating it.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • August 16, 2006 at 1:51 am

    #655204

    THANKS....that was wayyyyyyyyyyy to obvious !

    Thanks again,

    Eamon

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply