Post reply

Database Security

  • November 19, 2007 at 4:23 am

    #93633

    Hi all,

    I have multiple Database's on same server, i wants to owner rights on wone of them so that developer could change/add scripts/tables

    i am using sql server 2005

    how this could be done

    Thanks

  • November 19, 2007 at 6:14 am

    #752233

    Make sure whoever you want to be the owner of the database doesn't already exist as a user of the database. If so, you'll have to delete the user mapping. After that:

    ALTER AUTHORIZATION ON DATABASE::**Database Name** TO **New Owner**

    K. Brian Kelley
    @kbriankelley

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

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