Post reply

multiple owners

  • April 4, 2008 at 4:32 am

    #128468

    HI all,

    Please help me in this...

    I just want to know whether its possible to have multiple owners for database objects in sql server 2005 and 2000.If its so then how can i do that....

  • April 4, 2008 at 4:54 am

    #798306

    This isn't possible. You can have two objects with the same name that have different owners/schema. But they'll be different objects. For example, you could have Sales.SalesTable and Fred.SalesTable. Even though the object names are the same they're actually two distinct objects.

    Karl
    source control for SQL Server

  • April 4, 2008 at 5:24 am

    #798321

    Thanks Karl 🙂

  • April 4, 2008 at 10:33 pm

    #798764

    A small but important point with respect to SQL Server 2005... If the database is in 90 compatibility mode (SQL Server 2005 mode), technically your objects don't have owners. Your objects are contained in a schema. The schema has an owner.

    And also, in SQL Server 2005 there is the CONTROL permission. CONTROL doesn't make you an owner of a securable, but it gives you owner-like rights.

    K. Brian Kelley
    @kbriankelley

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

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